Re: Include sequences in publications created by pg_createsubscriber
vignesh C <vignesh21@gmail.com>
From: vignesh C <vignesh21@gmail.com>
To: Peter Smith <smithpb2250@gmail.com>
Cc: Shlok Kyal <shlok.kyal.oss@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-07-01T07:21:14Z
Lists: pgsql-hackers
Attachments
- v6-0001-Include-sequences-in-publications-created-by-pg_c.patch (application/octet-stream) patch v6-0001
On Wed, 1 Jul 2026 at 08:17, Peter Smith <smithpb2250@gmail.com> wrote: > > 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. The attached v6 version patch has the changes for the same. Regards, Vignesh
Commits
-
Add sequence synchronization for logical replication.
- 5509055d6956 19 (unreleased) cited
-
Add "ALL SEQUENCES" support to publications.
- 96b378497346 19 (unreleased) cited