From: Bruce Momjian <bruce@momjian.us>
To: Koen De Groote <kdg.dev@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Logical replication - initial data synchronization
Date: Thu, 17 Oct 2024 16:00:03 -0400
Message-ID: <ZxFsw41ucsXe8-5r@momjian.us> (raw)
In-Reply-To: <CAGbX52Fuc9f0_dKJiihTvB6y6+yB2m6anEvwP0FgKqYwHscJ3Q@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>
On Thu, Oct 17, 2024 at 09:57:04PM +0200, Koen De Groote wrote:
> I would still add that the snapshot and data copying is handled by postgres
> itself. That was the big question I was stuck with:"Who is taking this
> snapshot? Do I have to do it? Will they explain how?"
>
> Because it's left in the middle who does it. Once you know how logical
> replication works, it's obvious, re-reading the documentation I know what to
> expect, but that's only because I've already done it a few time snow.
>
> As someone just starting and reading the documentation, it was a stumbling
> block for me.
>
> To me,
>
> > When logical replication of a table typically starts, a snapshot is
> > taken of the table's data on the publisher database and copied to the
> > subscriber
>
> Does not clarify that.
>
> It's the reason I created this mail: I would like it stated explicitly that the
> database process takes care of this for us.
Well, you are the first person to report this confusion, and we can't go
around explaining what Postgres does and does not do in each section. I
would need to hear from other people that this is confusing before
making it explicit.
--
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?"
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, pgsql-docs@lists.postgresql.org
Subject: Re: Logical replication - initial data synchronization
In-Reply-To: <ZxFsw41ucsXe8-5r@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox