You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello!
Need some help with another case.
We copy all the tables in the public schema to clickhouse from Postgres. When a new table is added to Postgres, it will appear in the clickhouse only after the connector is restarted and the data already existing in the table in Postgres is updated again.
As a result, we lose some of the data in the new table.
Is there any way for the connector to take a snapshot of new tables and after that replicate them to the clickhouse?
Playback:
creating a table in Postgres
Filling it with data
The table does not appear in clickhouse.
connector restart
Still no table in clickhouse
update or insert new data into the postgres table
The table appears in the clickhouse, but it only contains data that was changed by the update/insert
thanks :)
The text was updated successfully, but these errors were encountered:
Hello!
Need some help with another case.
We copy all the tables in the public schema to clickhouse from Postgres. When a new table is added to Postgres, it will appear in the clickhouse only after the connector is restarted and the data already existing in the table in Postgres is updated again.
As a result, we lose some of the data in the new table.
Is there any way for the connector to take a snapshot of new tables and after that replicate them to the clickhouse?
Playback:
The table does not appear in clickhouse.
Still no table in clickhouse
thanks :)
The text was updated successfully, but these errors were encountered: