| From: | Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> |
|---|---|
| To: | vignesh C <vignesh21(at)gmail(dot)com> |
| Cc: | Peter Smith <smithpb2250(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Include sequences in publications created by pg_createsubscriber |
| Date: | 2026-06-29 14:36:52 |
| Message-ID: | CANhcyEWFi-FkBERbKcK+TKVnBThF1_qUbZ2gC-Lo6P4z7_05EQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>
> Thanks for the comments, here is an updated version with the fixes for the same.
>
Hi Vignesh,
I reviewed the patch, here are some comments:
1. In pg_createsubscriber.sgml:
+ 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 default mode, a pair of publication and subscription objects are
+ created for each database, and all tables and sequences in the specified
+ databases. By default, a pair of publication and subscription objects are
+ created for each database. It must be run at the target server.
1a. Line "a pair of publication and subscription objects are created
for each database"
is repeated twice.
1b. This line looks like something is missed:
```
In this default mode, a pair of publication and subscription objects are
created for each database, and all tables and sequences in the specified
```
maybe we can rewrite it as:
```
In this default mode, a pair of publication and subscription objects are created
for each database, publishing all tables and sequences in the
specified database.
```
2. '--publication' should be inside <option></option> tag.
+ the source server. If the --publication option is not specified,
+ <application>pg_createsubscriber</application> creates a publication
+ using <link linkend="sql-createpublication-params-for-all-tables">
3. For consistency, perhaps use "user-specified publications" here, as the later
documentation already refers to them using the same term.
+ For user-nominated publications, sequences are only replicated if they were
4. In 040_pg_createsubscriber.pl:
+is( $result, qq(t|t),
+ "publication is created with both all-tables and all-sequences enabled"
+);
extra space before $result. I think we should run pg_perltidy on the test file.
Thanks,
Shlok Kyal
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matheus Alcantara | 2026-06-29 14:41:33 | Re: Proposal: QUALIFY clause |
| Previous Message | Nathan Bossart | 2026-06-29 14:33:56 | Re: md5_password_warnings for password auth with MD5-encrypted passwords |