Date: Thu, 31 Oct 2024 11:16:36 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Koen De Groote <kdg.dev@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>,
	Peter Smith <smithpb2250@gmail.com>,
	pgsql-docs@lists.postgresql.org
Subject: Re: Logical replication - initial data synchronization
Message-ID: <ZyOfVJaq85OBZKiZ@momjian.us>
References: <171606613152.686.7693963105919927503@wrigleys.postgresql.org>
 <ZxBmaWEH-gX_rkUX@momjian.us>
 <CAGbX52HcDV7S5tEbsQEDWAJkfMBrm7OYaCmn_bt5shtm_Td-YQ@mail.gmail.com>
 <ZxEMSjl4gRWDeFO1@momjian.us>
 <CAGbX52Fuc9f0_dKJiihTvB6y6+yB2m6anEvwP0FgKqYwHscJ3Q@mail.gmail.com>
 <ZxFsw41ucsXe8-5r@momjian.us>
 <81ac7c432d4c0559c6489b43fe6984c4c1ee1fd3.camel@cybertec.at>
 <CAHut+PtUbJMQOZ9ka2nQXY7bXqyBreioNHviFxxh=MQXoLiofg@mail.gmail.com>
 <fac19453ba2df53a5efebf1a934baf49ff91a48a.camel@cybertec.at>
 <CAGbX52FOoZqokruugT2DhhQFc7ME-BJWjTTZq6q4JsGzO0Ytmg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="pcNnFxWfUwNcvpxe"
Content-Disposition: inline
In-Reply-To: 
 <CAGbX52FOoZqokruugT2DhhQFc7ME-BJWjTTZq6q4JsGzO0Ytmg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZyOfVJaq85OBZKiZ%40momjian.us>
Precedence: bulk


--pcNnFxWfUwNcvpxe
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Fri, Oct 25, 2024 at 11:48:16PM +0200, Koen De Groote wrote:
> Number 2 would be perfect, I think. It leaves no doubt at all.

I went with even more direct wording, patch attached.  Glad we could
improve this together --- the feedback from everyone was helpful.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  When a patient asks the doctor, "Am I going to die?", he means 
  "Am I going to die soon?"

--pcNnFxWfUwNcvpxe
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment; filename="logical.diff"

diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml
index 98a7ad0c272..111cc51f504 100644
--- a/doc/src/sgml/logical-replication.sgml
+++ b/doc/src/sgml/logical-replication.sgml
@@ -24,10 +24,11 @@
  </para>
 
  <para>
-  Logical replication of a table typically starts with taking a snapshot
-  of the data on the publisher database and copying that to the subscriber.
-  Once that is done, the changes on the publisher are sent to the subscriber
-  as they occur in real-time.  The subscriber applies the data in the same
+  When logical replication of a table typically starts, PostgreSQL takes
+  a snapshot of the table's data on the publisher database and copies it
+  to the subscriber.  Once complete, changes on the publisher since the
+  initial copy are sent continually to the subscriber.  The subscriber
+  applies the data in the same
   order as the publisher so that transactional consistency is guaranteed for
   publications within a single subscription.  This method of data replication
   is sometimes referred to as transactional replication.
@@ -165,7 +166,7 @@
    The individual tables can be added and removed dynamically using
    <link linkend="sql-alterpublication"><command>ALTER PUBLICATION</command></link>.  Both the <literal>ADD
    TABLE</literal> and <literal>DROP TABLE</literal> operations are
-   transactional; so the table will start or stop replicating at the correct
+   transactional, so the table will start or stop replicating at the correct
    snapshot once the transaction has committed.
   </para>
  </sect1>
@@ -1952,15 +1953,6 @@ CONTEXT:  processing remote data for replication origin "pg_16395" during "INSER
  <sect1 id="logical-replication-architecture">
   <title>Architecture</title>
 
-  <para>
-   Logical replication starts by copying a snapshot of the data on the
-   publisher database.  Once that is done, changes on the publisher are sent
-   to the subscriber as they occur in real time.  The subscriber applies data
-   in the order in which commits were made on the publisher so that
-   transactional consistency is guaranteed for the publications within any
-   single subscription.
-  </para>
-
   <para>
    Logical replication is built with an architecture similar to physical
    streaming replication (see <xref linkend="streaming-replication"/>).  It is

--pcNnFxWfUwNcvpxe--