Re: Handle infinite recursion in logical replication setup

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: vignesh C <vignesh21(at)gmail(dot)com>
Cc: "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "kuroda(dot)hayato(at)fujitsu(dot)com" <kuroda(dot)hayato(at)fujitsu(dot)com>, "shiy(dot)fnst(at)fujitsu(dot)com" <shiy(dot)fnst(at)fujitsu(dot)com>, "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
Subject: Re: Handle infinite recursion in logical replication setup
Date: 2022-08-29 06:31:07
Message-ID: CAHut+PvcfdxWc2Su8r+XTXnAw3CgKe+ON5XeVXbKFPchxcusrA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Here are some review comments for patch v42-0002:

======

1. doc/src/sgml/logical-replication.sgml

<literal>copy_data = true </literal>

There are a couple of these tags where there is a trailing space
before the </literal>. I guess it is doing no harm, but it is doing no
good either, so IMO better to get rid of the space.

~~

2. doc/src/sgml/logical-replication.sgml - 31.3.1. Setting replication
between two primaries

User need to ensure that no data changes happen on table t1 on
primary1 and primary2 until the setup is completed.

SUGGESTION
The user must ensure that no data changes happen on table t1 of
primary1 and primary2 until the setup is completed.

~~~

3. doc/src/sgml/logical-replication.sgml - 31.3.2. Adding a new
primary when there is no table data on any of the primaries

User need to ensure that no data changes happen on table t1 on all the
primaries primary1, primary2 and primary3 until the setup is
completed.

SUGGESTION
The user must ensure that no data changes happen on table t1 of all
the primaries primary1, primary2 and primary3 until the setup is
completed.

~~~

4. doc/src/sgml/logical-replication.sgml - 31.3.3. Adding a new
primary when table data is present on the existing primaries

User need to ensure that no operations should be performed on table t1
on primary2 and primary3 until the setup is completed.

SUGGESTION
The user must ensure that no operations are performed on table t1 of
primary2 and primary3 until the setup is completed.

Here also you changed the wording - "no data changes happen" versus
"no operations should be performed". Was that a deliberate difference?
Maybe they should all be consistent wording? If they are
interchangeable IMO the "no operations are performed..." wording was
the better of the two.

~~~

5. doc/src/sgml/logical-replication.sgml - 31.3.4. Generic steps for
adding a new primary to an existing set of primaries

Step-2: User need to ensure that no changes happen on the required
tables of the new primary until the setup is complete.

SUGGESTION
Step-2: The user must ensure that no changes happen on the required
tables of the new primary until the setup is complete.

~~~

6.

Step-4. User need to ensure that no changes happen on the required
tables of the existing primaries except the first primary until the
setup is complete.

SUGGESTION
Step-4. The user must ensure that no changes happen on the required
tables of the existing primaries except the first primary until the
setup is complete.

~~~

7. (the example)

7a.
Step-2. User need to ensure that no changes happen on table t1 on
primary4 until the setup is completed.

SUGGESTION
Step-2. The user must ensure that no changes happen on table t1 of
primary4 until the setup is completed.

~

7b.
Step-4. User need to ensure that no changes happen on table t1 on
primary2 and primary3 until the setup is completed.

SUGGESTION
Step-4. The user must ensure that no changes happen on table t1 of
primary2 and primary3 until the setup is completed.

------
Kind Regards,
Peter Smith.
Fujitsu Australia

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alex Fan 2022-08-29 07:46:22 [PATCH] Enable using llvm jitlink as an alternative llvm jit linker of old Rtdyld.
Previous Message Richard Guo 2022-08-29 06:30:23 Re: Making Vars outer-join aware