Re: Logical replication - initial data synchronization

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Bruce Momjian <bruce(at)momjian(dot)us>, Koen De Groote <kdg(dot)dev(at)gmail(dot)com>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Logical replication - initial data synchronization
Date: 2024-10-18 08:11:24
Message-ID: 81ac7c432d4c0559c6489b43fe6984c4c1ee1fd3.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Thu, 2024-10-17 at 16:00 -0400, Bruce Momjian wrote:
> > 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.

I for one would have interpreted the passive voice here as meaning that the
database does that automatically. But perhaps active voice can make it even
clearer:

Ordinarily, when logical replication of a table starts,
<productname>PostgreSQL</productname> takes a snapshot of the table's
data on the publisher database and copies these data to the subscriber

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2024-10-18 10:25:06 Re: Savepoint
Previous Message PG Doc comments form 2024-10-18 06:50:16 Savepoint