Re: Inaccurate statement about log shipping replication mode - Mailing list pgsql-docs

From Laurenz Albe
Subject Re: Inaccurate statement about log shipping replication mode
Date
Msg-id a67687e233188a43a80b55c4ab8e1115bf2bd947.camel@cybertec.at
Whole thread Raw
In response to Re: Inaccurate statement about log shipping replication mode  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Inaccurate statement about log shipping replication mode
List pgsql-docs
On Mon, 2025-08-25 at 09:58 +0200, Laurenz Albe wrote:
> On Thu, 2025-08-21 at 15:20 +0000, PG Doc comments form wrote:
> > Page: https://www.postgresql.org/docs/17/warm-standby.html
> >
> > The documentation page about Log-Shipping Standby Servers after describing
> > that there are file-based log shipping and record-based log shipping
> > (streaming replication) states: "It should be noted that log shipping is
> > asynchronous, i.e., the WAL records are shipped after transaction commit.".
> > This statement is misleading because the same page includes a section about
> > configuring synchronous streaming replication. To avoid confusion, I think
> > it makes sense to specify that record-based log shipping can be configured
> > as either asynchronous or synchronous.
>
> I think that the statement you quote is not only misleading, but wrong.
> WAL can get shipped before the transaction commits.  Perhaps the sentence
> had better be
>
>   It should be noted that by default, log shipping is asynchronous, i.e.,
>   the primary server does not wait until the standby receives the data.

Here is a patch for that.

Yours,
Laurenz Albe

Attachment

pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Small typo in doc
Next
From: "David G. Johnston"
Date:
Subject: Re: Ambiguity in VALUES synopsis: LIMIT vs FETCH