From: Euler Taveira <euler@eulerto.com>
To: Masahiko Sawada <sawada.mshk@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Cc: Peter Eisentraut <peter@eisentraut.org>
Subject: Re: pg_createsubscriber clarification
Date: Tue, 30 Jul 2024 18:02:51 -0300
Message-ID: <1802dbe8-d136-4ea3-bc31-bffc41b2cd27@app.fastmail.com> (raw)
In-Reply-To: <CAD21AoCKqU8GPoAKA3V_-JD40tXR6VndekCV0Cx_9RMsGRVoYQ@mail.gmail.com>
References: <ZqX_4J-nFTQtmj6K@momjian.us>
<CAD21AoCKqU8GPoAKA3V_-JD40tXR6VndekCV0Cx_9RMsGRVoYQ@mail.gmail.com>
On Sun, Jul 28, 2024, at 1:17 PM, Masahiko Sawada wrote:
> I think the term "synchronization phase" comes from the description in
> "29.8.1. Initial Snapshot" section[1].
Yes.
> https://www.postgresql.org/docs/17/logical-replication-architecture.html#LOGICAL-REPLICATION-SNAPSHO...
>
> How about the following?
>
> The main difference between the logical replication setup and
> pg_createsubscriber is how they synchronize table data.
> pg_createsubscriber doesn't copy the initial table data because it
> uses the tables with their initial data on the target server. It only
> does the synchronization phase, which ensures each table is brought up
> to a synchronized state by applying changes using standard logical
> replication.
I slightly modified your proposal in the attached patch.
Thoughts?
--
Euler Taveira
EDB https://www.enterprisedb.com/Attachments:
[text/x-patch] doc.patch (992B, ../1802dbe8-d136-4ea3-bc31-bffc41b2cd27@app.fastmail.com/3-doc.patch)
download | inline diff:diff --git a/doc/src/sgml/ref/pg_createsubscriber.sgml b/doc/src/sgml/ref/pg_createsubscriber.sgmlindex 87a9d3db28e..6ebf918b636 100644--- a/doc/src/sgml/ref/pg_createsubscriber.sgml+++ b/doc/src/sgml/ref/pg_createsubscriber.sgml@@ -57,9 +57,10 @@ PostgreSQL documentation
<para>
After a successful run, the state of the target server is analogous to a
fresh logical replication setup. The main difference between the logical
- replication setup and <application>pg_createsubscriber</application> is the- initial data copy. It does only the synchronization phase, which ensures- each table is brought up to a synchronized state.+ replication setup and <application>pg_createsubscriber</application> is how+ the data synchronization is done. <application>pg_createsubscriber</application>+ does not copy the initial table data. It does only the synchronization phase,+ which ensures each table is brought up to a synchronized state.
</para>
<para>
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: euler@eulerto.com, sawada.mshk@gmail.com, bruce@momjian.us, peter@eisentraut.org
Subject: Re: pg_createsubscriber clarification
In-Reply-To: <1802dbe8-d136-4ea3-bc31-bffc41b2cd27@app.fastmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox