pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_createsubscriber clarification
4+ messages / 3 participants
[nested] [flat]
* pg_createsubscriber clarification
@ 2024-07-28 08:22 Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2024-07-28 08:22 UTC (permalink / raw)
To: pgsql-docs; +Cc: Peter Eisentraut <peter@eisentraut.org>
The pg_createsubscriber docs say:
https://www.postgresql.org/docs/17/app-pgcreatesubscriber.html
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 pg_createsubscriber is the
initial data copy. It does only the synchronization phase, which
ensures each table is brought up to a synchronized state.
What does "it" and "synchronization phase" mean in "It does only the
synchronization phase"? Seems this needs improvement.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_createsubscriber clarification
@ 2024-07-28 16:17 Masahiko Sawada <sawada.mshk@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 4+ messages in thread
From: Masahiko Sawada @ 2024-07-28 16:17 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-docs; Peter Eisentraut <peter@eisentraut.org>
On Sun, Jul 28, 2024 at 1:23 AM Bruce Momjian <bruce@momjian.us> wrote:
>
> The pg_createsubscriber docs say:
>
> https://www.postgresql.org/docs/17/app-pgcreatesubscriber.html
>
> 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 pg_createsubscriber is the
> initial data copy. It does only the synchronization phase, which
> ensures each table is brought up to a synchronized state.
>
> What does "it" and "synchronization phase" mean in "It does only the
> synchronization phase"? Seems this needs improvement.
+1 to improve the description.
I think the term "synchronization phase" comes from the description in
"29.8.1. Initial Snapshot" section[1].
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.
Regards,
--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_createsubscriber clarification
@ 2024-07-30 21:02 Euler Taveira <euler@eulerto.com>
parent: Masahiko Sawada <sawada.mshk@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Euler Taveira @ 2024-07-30 21:02 UTC (permalink / raw)
To: Masahiko Sawada <sawada.mshk@gmail.com>; Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-docs; Peter Eisentraut <peter@eisentraut.org>
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.sgml
index 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>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_createsubscriber clarification
@ 2024-08-19 22:27 Bruce Momjian <bruce@momjian.us>
parent: Euler Taveira <euler@eulerto.com>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2024-08-19 22:27 UTC (permalink / raw)
To: Euler Taveira <euler@eulerto.com>; +Cc: Masahiko Sawada <sawada.mshk@gmail.com>; pgsql-docs; Peter Eisentraut <peter@eisentraut.org>
Thanks, patch applied to PG 17 and master.
---------------------------------------------------------------------------
On Tue, Jul 30, 2024 at 06:02:51PM -0300, Euler Taveira wrote:
> 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-SNAPSHOT
>
> 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/
>
> diff --git a/doc/src/sgml/ref/pg_createsubscriber.sgml b/doc/src/sgml/ref/pg_createsubscriber.sgml
> index 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>
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-08-19 22:27 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-07-28 08:22 pg_createsubscriber clarification Bruce Momjian <bruce@momjian.us>
2024-07-28 16:17 ` Masahiko Sawada <sawada.mshk@gmail.com>
2024-07-30 21:02 ` Euler Taveira <euler@eulerto.com>
2024-08-19 22:27 ` Bruce Momjian <bruce@momjian.us>
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