>DDL changes are also tricky You can use triggers to write DDL to a table which is then replicated (and optionally use triggers or app logic on the consumer si

>DDL changes are also tricky You can use triggers to write DDL to a table which is then replicated (and optionally use triggers or app logic on the consumer side to process them) >Snapshots I feel like these are way under documented. You can combine with tools like pg_dump and set "section" or schema only dump. Pgcopydb also supports snapshots or even combined with plain COPY I recently learned SUBSCRIPTIONS with data copy just automate snapshots, COPY, and appear to have some optimization to speed up initial sync with multiple replication slots (I originally thought there was something special at the protocol level)