Re: Documentation to upgrade logical replication cluster

2024-05-05 Thread vignesh C
On Fri, 23 Feb 2024 at 04:58, Peter Smith wrote: > > Hi Vignesh, I have no further comments. Patch v9 LGTM. The v9 version patch was not applying on top of HEAD because of few commits, the updated v10 version patch is rebased on top of HEAD. Regards, Vignesh From

Re: Documentation to upgrade logical replication cluster

2024-02-22 Thread Peter Smith
Hi Vignesh, I have no further comments. Patch v9 LGTM. == Kind Regards, Peter Smith. Fujitsu Australia

Re: Documentation to upgrade logical replication cluster

2024-02-22 Thread vignesh C
On Thu, 22 Feb 2024 at 09:35, Peter Smith wrote: > > Here are some minor comments for patch v8-0001. > > == > doc/src/sgml/glossary.sgml > > 1. > + > + > + A set of publisher and subscriber instances with publisher instance > + replicating changes to the subscriber instance. >

Re: Documentation to upgrade logical replication cluster

2024-02-21 Thread Peter Smith
Here are some minor comments for patch v8-0001. == doc/src/sgml/glossary.sgml 1. + + + A set of publisher and subscriber instances with publisher instance + replicating changes to the subscriber instance. + + /with publisher instance/with the publisher instance/ ~~~

Re: Documentation to upgrade logical replication cluster

2024-02-12 Thread vignesh C
On Mon, 12 Feb 2024 at 14:33, vignesh C wrote: > > On Fri, 9 Feb 2024 at 12:30, Peter Smith wrote: > > > > Here are some review comments for patch v7-0001. > > > > == > > doc/src/sgml/glossary.sgml > > > > 1. > > + > > + Logical replication cluster > > + > > + > > + A set of

Re: Documentation to upgrade logical replication cluster

2024-02-12 Thread vignesh C
On Fri, 9 Feb 2024 at 12:30, Peter Smith wrote: > > Here are some review comments for patch v7-0001. > > == > doc/src/sgml/glossary.sgml > > 1. > + > + Logical replication cluster > + > + > + A set of publisher and subscriber instance with publisher instance > + replicating

Re: Documentation to upgrade logical replication cluster

2024-02-09 Thread vignesh C
On Thu, 1 Feb 2024 at 14:50, vignesh C wrote: > > On Wed, 31 Jan 2024 at 11:42, Hayato Kuroda (Fujitsu) > wrote: > > > > Dear Vignesh, > > > > Thanks for updating the patch! Here are my comments for v6. > > > > 01. > > ``` > > + Logical replication cluster > > + > > + > > + A set of

Re: Documentation to upgrade logical replication cluster

2024-02-08 Thread Peter Smith
Here are some review comments for patch v7-0001. == doc/src/sgml/glossary.sgml 1. + + Logical replication cluster + + + A set of publisher and subscriber instance with publisher instance + replicating changes to the subscriber instance. + + + 1a. /instance

Re: Documentation to upgrade logical replication cluster

2024-02-01 Thread vignesh C
On Wed, 31 Jan 2024 at 11:42, Hayato Kuroda (Fujitsu) wrote: > > Dear Vignesh, > > Thanks for updating the patch! Here are my comments for v6. > > 01. > ``` > + Logical replication cluster > + > + > + A set of publisher and subscriber instance with publisher instance > +

RE: Documentation to upgrade logical replication cluster

2024-01-30 Thread Hayato Kuroda (Fujitsu)
Dear Vignesh, Thanks for updating the patch! Here are my comments for v6. 01. ``` + Logical replication cluster + + + A set of publisher and subscriber instance with publisher instance + replicating changes to the subscriber instance. + + ``` Should we say 1:N

Re: Documentation to upgrade logical replication cluster

2024-01-30 Thread vignesh C
On Mon, 29 Jan 2024 at 16:01, Bharath Rupireddy wrote: > > On Mon, Jan 29, 2024 at 10:10 AM vignesh C wrote: > > > > Thanks for the comments, the attached v5 version patch has the changes > > for the same. > > Thanks for working on this. Here are some comments on the v5 patch: > > 1. > + > +

Re: Documentation to upgrade logical replication cluster

2024-01-29 Thread Bharath Rupireddy
On Mon, Jan 29, 2024 at 10:10 AM vignesh C wrote: > > Thanks for the comments, the attached v5 version patch has the changes > for the same. Thanks for working on this. Here are some comments on the v5 patch: 1. + + Migration of logical replication clusters is possible only when all the +

Re: Documentation to upgrade logical replication cluster

2024-01-28 Thread vignesh C
On Mon, 29 Jan 2024 at 06:34, Peter Smith wrote: > > Hi Vignesh, > > Here are some review comments for patch v4. > > These are cosmetic only; otherwise v4 LGTM. > > == > doc/src/sgml/ref/pgupgrade.sgml > > 1. > Configure the servers for log shipping. (You do not need to run >

RE: Documentation to upgrade logical replication cluster

2024-01-28 Thread Hayato Kuroda (Fujitsu)
Dear Vignesh, Thanks for updating the patch! For now, v4 patch LGTM. Best Regards, Hayato Kuroda FUJITSU LIMITED https://www.fujitsu.com/

Re: Documentation to upgrade logical replication cluster

2024-01-28 Thread Peter Smith
Hi Vignesh, Here are some review comments for patch v4. These are cosmetic only; otherwise v4 LGTM. == doc/src/sgml/ref/pgupgrade.sgml 1. Configure the servers for log shipping. (You do not need to run pg_backup_start() and pg_backup_stop() or take a file system

Re: Documentation to upgrade logical replication cluster

2024-01-25 Thread vignesh C
On Thu, 25 Jan 2024 at 05:45, Peter Smith wrote: > > Here are some review comments for patch v3. > > == > doc/src/sgml/ref/pgupgrade.sgml > > 1. > + > + > + This page does not cover steps to upgrade logical replication > clusters, refer > +for details on upgrading > + logical

Re: Documentation to upgrade logical replication cluster

2024-01-25 Thread vignesh C
On Wed, 24 Jan 2024 at 15:16, Hayato Kuroda (Fujitsu) wrote: > > Dear Vignesh, > > Thanks for updating the patch! Basically your patch looks good. > Below lines are my comments for v3. > > 01. > > ``` > > The output plugins referenced by the slots on the old cluster must be >

Re: Documentation to upgrade logical replication cluster

2024-01-24 Thread Peter Smith
Here are some review comments for patch v3. == doc/src/sgml/ref/pgupgrade.sgml 1. + + + This page does not cover steps to upgrade logical replication clusters, refer +for details on upgrading + logical replication clusters. + + I felt that maybe this note was misplaced. Won't it

RE: Documentation to upgrade logical replication cluster

2024-01-24 Thread Hayato Kuroda (Fujitsu)
Dear Vignesh, Thanks for updating the patch! Basically your patch looks good. Below lines are my comments for v3. 01. ``` The output plugins referenced by the slots on the old cluster must be installed in the new PostgreSQL executable directory. ``` PostgreSQL must be

Re: Documentation to upgrade logical replication cluster

2024-01-23 Thread vignesh C
On Mon, 15 Jan 2024 at 14:39, Hayato Kuroda (Fujitsu) wrote: > > Dear Vignesh, > > Thanks for updating the patch! > > > > 7. > > > ``` > > > + > > > +dba@node1:/opt/PostgreSQL/postgres//bin$ pg_ctl -D > > /opt/PostgreSQL/pub_data stop -l logfile > > > + > > > ``` > > > > > > Hmm. I thought you

Re: Documentation to upgrade logical replication cluster

2024-01-23 Thread vignesh C
On Mon, 15 Jan 2024 at 09:01, Peter Smith wrote: > > Hi Vignesh, here are some review comments for patch v2-0001. > > == > doc/src/sgml/ref/pgupgrade.sgml > > 1. > + > +Upgrade logical replication clusters > + > + > + Refer logical > replication upgrade section > + for

RE: Documentation to upgrade logical replication cluster

2024-01-15 Thread Hayato Kuroda (Fujitsu)
Dear Vignesh, Thanks for updating the patch! > > 7. > > ``` > > + > > +dba@node1:/opt/PostgreSQL/postgres//bin$ pg_ctl -D > /opt/PostgreSQL/pub_data stop -l logfile > > + > > ``` > > > > Hmm. I thought you did not have to show the current directory. You were in > > the > > bin dir, but it is

Re: Documentation to upgrade logical replication cluster

2024-01-14 Thread Peter Smith
Hi Vignesh, here are some review comments for patch v2-0001. == doc/src/sgml/ref/pgupgrade.sgml 1. + +Upgrade logical replication clusters + + + Refer logical replication upgrade section + for details on upgrading logical replication clusters. + + + + This renders

Re: Documentation to upgrade logical replication cluster

2024-01-13 Thread vignesh C
On Fri, 5 Jan 2024 at 10:49, Peter Smith wrote: > > Here are some review comments for patch v1-0001. > > == > doc/src/sgml/ref/pgupgrade.sgml > > 1. GENERAL - blank lines > > Most (but not all) of your procedure steps are preceded by blank lines > to make them more readable in the SGML. Add

Re: Documentation to upgrade logical replication cluster

2024-01-13 Thread vignesh C
On Fri, 5 Jan 2024 at 09:08, Hayato Kuroda (Fujitsu) wrote: > > Dear Vignesh, > > Thanks for making a patch! Below part is my comments. > > 1. > Only two steps were added an id, but I think it should be for all the steps. > See [1]. I have added wherever it is required as of now. > 2. > I'm not

Re: Documentation to upgrade logical replication cluster

2024-01-10 Thread vignesh C
On Wed, 10 Jan 2024 at 15:50, Amit Kapila wrote: > > On Thu, Jan 4, 2024 at 2:22 PM vignesh C wrote: > > > > We have documentation on how to upgrade "publisher" and "subscriber" > > at [1], but currently we do not have any documentation on how to > > upgrade logical replication clusters. > >

Re: Documentation to upgrade logical replication cluster

2024-01-10 Thread Amit Kapila
On Mon, Jan 8, 2024 at 12:52 PM Bharath Rupireddy wrote: > > On Thu, Jan 4, 2024 at 2:22 PM vignesh C wrote: > > > > Hi, > > > > We have documentation on how to upgrade "publisher" and "subscriber" > > at [1], but currently we do not have any documentation on how to > > upgrade logical

Re: Documentation to upgrade logical replication cluster

2024-01-10 Thread Amit Kapila
On Thu, Jan 4, 2024 at 2:22 PM vignesh C wrote: > > We have documentation on how to upgrade "publisher" and "subscriber" > at [1], but currently we do not have any documentation on how to > upgrade logical replication clusters. > Here is a patch to document how to upgrade different logical >

Re: Documentation to upgrade logical replication cluster

2024-01-07 Thread Bharath Rupireddy
On Thu, Jan 4, 2024 at 2:22 PM vignesh C wrote: > > Hi, > > We have documentation on how to upgrade "publisher" and "subscriber" > at [1], but currently we do not have any documentation on how to > upgrade logical replication clusters. > Here is a patch to document how to upgrade different

Re: Documentation to upgrade logical replication cluster

2024-01-04 Thread Peter Smith
On Fri, Jan 5, 2024 at 2:38 PM Hayato Kuroda (Fujitsu) wrote: ... > 2. > I'm not sure it should be listed as step 10. I felt that it should be new > section. > At that time other steps like "Prepare for {publisher|subscriber} upgrades" > can be moved as well. > Thought? During my review, I

Re: Documentation to upgrade logical replication cluster

2024-01-04 Thread Peter Smith
Here are some review comments for patch v1-0001. == doc/src/sgml/ref/pgupgrade.sgml 1. GENERAL - blank lines Most (but not all) of your procedure steps are preceded by blank lines to make them more readable in the SGML. Add the missing blank lines for the steps that didn't have them. 2.

RE: Documentation to upgrade logical replication cluster

2024-01-04 Thread Hayato Kuroda (Fujitsu)
Dear Vignesh, Thanks for making a patch! Below part is my comments. 1. Only two steps were added an id, but I think it should be for all the steps. See [1]. 2. I'm not sure it should be listed as step 10. I felt that it should be new section. At that time other steps like "Prepare for

Documentation to upgrade logical replication cluster

2024-01-04 Thread vignesh C
Hi, We have documentation on how to upgrade "publisher" and "subscriber" at [1], but currently we do not have any documentation on how to upgrade logical replication clusters. Here is a patch to document how to upgrade different logical replication clusters: a) Upgrade 2 node logical replication