public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: [email protected]
To: [email protected]
Subject: Re: Inaccurate statement about log shipping replication mode
Date: Mon, 25 Aug 2025 09:58:29 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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.

Yours,
Laurenz Albe

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Inaccurate statement about log shipping replication mode
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox