Re: Logical replication - initial data synchronization

> But perhaps active voice can make it even clearer:

That would be nice. It immediately clarifies the actor, instead of
basically saying "it's expected that an action was performed".

To give some context, jobs over the past decade have taught me to work on a
default setting of "If it isn't explicitly stated, it cannot be assumed and
has to be tested first. Lack of explicit statement is lack of a guarantee,
and if you don't test it, you'll run into issues down the line."

To Bruce: I get that concern in general. But I feel like people don't
complain because at some point they figure it out, and then it's no longer
an issue for them. But it was initially, and it did cost them time. Most
people will work with PostgreSQL for their job and their job will demand
timely delivery from them. Sending mails like this is probably something
most people aren't going to take time for.

At least, that's how I see the situation. It may be presumptive of me.

I realize this has taken a bit of time already, and for my part, I would
like the more explicit statement, as shown by Laurenz, but I'm not going to
keep going on about it if it doesn't make its way in.

Regards,
Koen De Groote

On Fri, Oct 18, 2024 at 10:11 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> 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
>