Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

new table in Postgresql #438

Closed
tellienne opened this issue Jan 17, 2024 · 1 comment · Fixed by #439
Closed

new table in Postgresql #438

tellienne opened this issue Jan 17, 2024 · 1 comment · Fixed by #439

Comments

@tellienne
Copy link

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:

  1. creating a table in Postgres
  2. Filling it with data
    The table does not appear in clickhouse.
  3. connector restart
    Still no table in clickhouse
  4. update or insert new data into the postgres table
  5. The table appears in the clickhouse, but it only contains data that was changed by the update/insert

thanks :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
2 participants