Re: Logical replication - initial data synchronization

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.

Regards,
Koen De Groote

On Thu, Oct 17, 2024 at 3:08 PM Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> On Thu, Oct 17, 2024 at 10:59:51AM +0200, Koen De Groote wrote:
> > Hello Bruce, thanks for picking this up.
> >
> > Personally, I would make explicit mention of the fact that creating the
> > snapshot and copying the data is taken care of by Postgres itself. Those
> are
> > the points that had me confused early on, wondering if I had to perform
> the
> > copy once the snapshot was ready.
>
> Updated patch attached. I tried to tighten up the wording and add more
> detail. I didn't see the point in repeating the same paragraph later on
> so I removed it.
>
> --
> Bruce Momjian <bruce(at)momjian(dot)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?"
>