Re: Include sequences in publications created by pg_createsubscriber
Peter Smith <smithpb2250@gmail.com>
From: Peter Smith <smithpb2250@gmail.com>
To: vignesh C <vignesh21@gmail.com>
Cc: Shlok Kyal <shlok.kyal.oss@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-07-01T02:46:39Z
Lists: pgsql-hackers
A review comment for patch v5-0001 ====== doc/src/sgml/ref/pg_createsubscriber.sgml 1. + replica from a physical standby server. By default, + <application>pg_createsubscriber</application> configures + <link linkend="logical-replication">logical replication</link> by + automatically creating internal publication and subscription objects. In + this mode, a publication and subscription are created for each database, and + the publications include all tables and sequences in their respective + databases. When user-specified publications are used, the subscriptions + replicate only the objects included in those publications. It must be run at + the target server. In that last sentence, I felt it might be better to avoid saying "It" which could be misunderstood as referring to something other than the tool itself. BEFORE It must be run at the target server. SUGGESTION <application>pg_createsubscriber</application> must be run at the target server. ====== Kind Regards, Peter Smith. Fujitsu Australia
Commits
-
Add sequence synchronization for logical replication.
- 5509055d6956 19 (unreleased) cited
-
Add "ALL SEQUENCES" support to publications.
- 96b378497346 19 (unreleased) cited