Re: Include sequences in publications created by pg_createsubscriber

> On Jul 9, 2026, at 16:41, vignesh C <vignesh21(at)gmail(dot)com> wrote:
>
> On Thu, 9 Jul 2026 at 07:07, Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
>>
>> Some review comments for v8
>>
>> ======
>> doc/src/sgml/ref/pg_createsubscriber.sgml
>>
>> 1.
>> + which ensures each table is brought up to a synchronized state. When using
>> + internally generated publications, the publications automatically include
>> + all sequences in the database; however, sequence values are not
>> + automatically synchronized.
>>
>> Maybe "automatically" 2x in the same sentence is a bit much. The rest
>> can also be simpler.
>>
>> SUGGESTION
>> Internally generated publications include all sequences in the
>> database, but their values are not automatically synchronized.
>>
>> ~~~
>>
>> 2.
>> + objects defined by that publication. Otherwise,
>> + <application>pg_createsubscriber</application> creates a publication
>> + using <link linkend="sql-createpublication-params-for-all-tables">
>> + <literal>FOR ALL TABLES</literal></link> and <link
>> + linkend="sql-createpublication-params-for-all-sequences"> <literal>ALL
>> + SEQUENCES</literal></link>. These generated publications has the
>> + following name pattern:
>>
>> 2a.
>> The space before the last <literal> tag here is probably not deliberate.
>>
>> ~
>>
>> 2b.
>> typo: /has the/have the/
>
> Thanks for the comments, the attached v9 version patch has the changes
> for the same.
>
> Regards,
> Vignesh
> <v9-0001-Include-sequences-in-publications-created-by-pg_c.patch>

V9 overall looks good. A few small comments:

1
```
+# run pg_createsubscriber with '--all' with debug verbose logging enabled
my ($stdout, $stderr) = run_command(
[
'pg_createsubscriber',
'--verbose',
+ '--verbose',
```

The test already had —verbose, adding the option again is redundant.

2
```
+ Create a publication and replication slot for each specified database
+ on the source server. If the <option>--publication</option> option is
+ specified, the user-specified publication is used, which includes the
+ objects defined by that publication. Otherwise,
```

This statement doesn’t seem precise to me. --publication might specify a non-existing publication, in which case a new publication will be created, but “the user-specified publication is used” seems to imply that the specified publication must already exist.

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/