4 ms·
I see PeerDB supports CDC on partitioned tables. Does it support replicating parent/child (INHERIT) tables from postgres?
by gregw2 2y ago
I see PeerDB supports CDC on partitioned tables. Does it support replicating parent/child (INHERIT) tables from postgres?
- saisrirampur 2y agoGreat question! I'm expecting it to support parent/child tables too as the way we implemented partitioned table support is querying the pg_inherits metadata table - https://github.com/PeerDB-io/peerdb/blob/2d30e5fae887552f93cc7d0d4448afb3a1b43d2a/flow/connectors/postgres/cdc.go#L75 https://github.com/PeerDB-io/peerdb/blob/2d30e5fae887552f93c... However, inheritance (old way of partitioning) isn't a common thing with Postgres. Out of 100s of workloads I've seen in the past decade, it came up a couple of times...