Hi there folks! `TL;DR; Can I run a single-stream...
# replication-troubleshooting
g
Hi there folks!
TL;DR; Can I run a single-stream sync for any Postgres to Postgres connection?
Is there any way of syncing a SINGLE stream from a connection? I found no API calls for this here. Use case: • We have a pretty big hourly sync (postgres to postgres) • Sometimes we want to update only a subset of tables from this sync • Running the pretty big sync takes time and we want to do this faster. I thought of creating another connection with the same SRC <-> DST but I'm afraid this will mess incremental cursors.
e
If you aren't using CDC, and your cursor is a column in the table, it should be fine to have 2 connections: • Table A - which is fast, and runs every hour • Tables B,C,D... - which is slow and runs every day
Actually, it's probably going to be fine if you use CDC too. The trick is just to not move the same table twice - don't move table A in both connections
1