agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedFrom: Bruce Momjian <bruce@momjian.us>
To: Koen De Groote <kdg.dev@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Peter Smith <smithpb2250@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Logical replication - initial data synchronization
Date: Thu, 31 Oct 2024 11:16:36 -0400
Message-ID: <ZyOfVJaq85OBZKiZ@momjian.us> (raw)
In-Reply-To: <CAGbX52FOoZqokruugT2DhhQFc7ME-BJWjTTZq6q4JsGzO0Ytmg@mail.gmail.com>
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>
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?"
Attachments:
[text/x-diff] logical.diff (2.3K, ../ZyOfVJaq85OBZKiZ@momjian.us/2-logical.diff)
download | inline 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
view thread (22+ messages) latest in thread
Message-ID: <ZyOfVJaq85OBZKiZ@momjian.us>
Permalink: ../ZyOfVJaq85OBZKiZ@momjian.us/
Also on: postgresql.org/message-id/ZyOfVJaq85OBZKiZ@momjian.us
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, kdg.dev@gmail.com, laurenz.albe@cybertec.at, smithpb2250@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Logical replication - initial data synchronization
In-Reply-To: <ZyOfVJaq85OBZKiZ@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox