ISTM pg_dump should alter publication/subscription when doing partial dumps, similar to how it handles foreign keys.

Subscribed tables should be read-only by default. If you need something more advanced than that adding an extra option to the subscription (or wherever else) is going to be the least of your worries. If we don't want to get too wrapped up in config/syntax I think there should at least be a read-only statement level trigger installed by default that users can then drop or disable if desired.
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble!
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

Reply via email to