hey, I am using a airbyte connector from postgres to postgres, it is creating an additional copy of the tables that I am replicating every time I sync and the db is running out of space, is there a way I can stop airbyte from making multiple copies of the same table?

@Prateek Gupta unfortunately currently there is no way to stop creating the

_airbyte_tmp_lsc_tableName

table

the problem is that it is creating multipe tables like this

Are the sync job succedded? These tables should be removed after the sync is finished.

no, the sync is failing and hence I am gettin many tables of this type as they fail

Hey any reason why sync is failing ?

can't really say, if its a problem on infra or the program, the table is around 60GB and 100 mn rows from postgresql to postgresql

Hey Prateek can you monitor database logs and see if you can get something there.

could not write to file "base/pgsql_tmp/pgsql_tmp11974.1": No space left on device