Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1utgXR-00CZlz-2h for pgsql-docs@arkaria.postgresql.org; Wed, 03 Sep 2025 06:00:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1utgXQ-007BL4-0z for pgsql-docs@arkaria.postgresql.org; Wed, 03 Sep 2025 06:00:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1utgXP-007BKw-Pw for pgsql-docs@lists.postgresql.org; Wed, 03 Sep 2025 06:00:08 +0000 Received: from fhigh-a2-smtp.messagingengine.com ([103.168.172.153]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1utgXO-000HKI-21 for pgsql-docs@lists.postgresql.org; Wed, 03 Sep 2025 06:00:07 +0000 Received: from phl-compute-09.internal (phl-compute-09.internal [10.202.2.49]) by mailfhigh.phl.internal (Postfix) with ESMTP id 3BDF514003F7; Wed, 3 Sep 2025 02:00:06 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-09.internal (MEProxy); Wed, 03 Sep 2025 02:00:06 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1756879206; x=1756965606; bh=YKqRHFSOEZ iLoy5lzXeUs7PbpRkv68xBeKO1UN2EuME=; b=Ns5r+mfNBIQUZc9+Aj/xts0Rls QLRQhgBRKJjRyYU9eJnM/oexh8H4le0asKlV8Rdl5tjBQr9JrngjNVS+3nPHf+sK sdIkbXOQX0QlZioqt79V1DRIvAe09Xan9Xx9lZvdEKzt0D6zWaRvwzl+iVbIMk2k fUKdGZ2/87IMDY+XzKzI+utYQC+gXYBew5DFxwFlQ0viPURM80Pveypz5bRq9Yaa KbC4jbeLc/63rD1RlzwMW0y/j+fK5MOHE0Rv92uw1WeHHgmt4uPNOND8OiJhSjvW pIW5shgBFs8bb+lM8dZJjpsNcixLNib1TAhz8kM9H6VsEOfB+Kk+Upi+Ddvw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1756879206; x=1756965606; bh=YKqRHFSOEZiLoy5lzXeUs7PbpRkv68xBeKO 1UN2EuME=; b=EZtYdaP0fbMexd1r5UedcI26vZV2vsWDKdAhYrvRsdzMMin82CO G7Elp+9J0HE71yDgChH366ZD3UYLYhdB2hPzGV/CBe9iwIdA5TFD9A7BM7BNUhXX S5LAmozdTqLPOwMkX4nohLNVZyUT+q10ER6GPwACJcyKbJUrWzhJooHjXKI3elMf y9OU16bP7HTAWMUKabD7yw0Wh88BRNwTJNS6D13+/BMrTMZOm0qoPUZctWo9nXk2 aZwZ18mvuaqxBAnW5EL5XTxB8s3wNXiN7ACjS73EDTknhQsF5DT+mBlybcHjxWOS vCRARlXR8zgXV0mQXHjgnClVJ7LmVq+pktw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddvfeejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceurghi lhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrhhluc fvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredttddvnecu hfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqhhuih gvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeggeegfffh keeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptdenucfrrg hrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiidpnhgs pghrtghpthhtohepgedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtoheprhhosgesgi iiihhllhgrrdhnvghtpdhrtghpthhtoheplhgruhhrvghniidrrghlsggvsegthigsvghr thgvtgdrrghtpdhrtghpthhtoheprghrthgvmhdrghgrvhhrihhlohhvsehpvghrtghonh grrdgtohhmpdhrtghpthhtohepphhgshhqlhdqughotghssehlihhsthhsrdhpohhsthhg rhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 3 Sep 2025 02:00:03 -0400 (EDT) Date: Wed, 3 Sep 2025 14:59:50 +0900 From: Michael Paquier To: Robert Treat Cc: Laurenz Albe , Artem Gavrilov , pgsql-docs@lists.postgresql.org Subject: Re: Inaccurate statement about log shipping replication mode Message-ID: References: <175578964049.806.14564779365418625473@wrigleys.postgresql.org> <568ff8638e011b2726d06a4b95124ec51ee1e5af.camel@cybertec.at> <93913aeb398b264ca0dc781095d36d6ad2d3be71.camel@cybertec.at> <60948f2ce0f59a8406208e8feabe667f170e8676.camel@cybertec.at> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="7lAF9h8SUnIEwJfu" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --7lAF9h8SUnIEwJfu Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Sep 02, 2025 at 11:10:42AM -0400, Robert Treat wrote: > So with that said, I would suggest fixing this by changing the first > sentence of paragraph 4 to "It should be noted that file based log > shipping is asynchronous", as this also emphasizes that this section > is focused on file based wal shipping. Not sure that there is a strong need for "file-based", still it is true that we could just remove the inexact part of the sentence and call it a day, as of: --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -527,8 +527,7 @@ protocol to make nodes agree on a serializable transact= ional order. =20 - It should be noted that log shipping is asynchronous, i.e., the WAL - records are shipped after transaction commit. As a result, there is a + It should be noted that log shipping is asynchronous. As a result, ther= e is a -- Michael --7lAF9h8SUnIEwJfu Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmi32VYACgkQnvQgOdby QH0M2xAAjnSekRWjTLVZUtvPWYNHMc/wHWDgMgUyT4DyeoitWuPjildHHNzON+iU rV58N0Kuq9Lnp6pS6x8blCvjo0FfyoDhutWBkF6FMtjXxg/PdaLTl9zX7+GhZFy0 hK21gL5CiKb31bVf+FQu5vfDuZnUVsBWdZjHmsvYgj6qoah+gFPyv1LMkg9bLtST ouAsnjIESSpXByjdYA6oeMDlYt4AYUCGMYEDHiYS+ql7vMWw/WIANOzMDstPnln2 dgUZ41OH5L9Wts7rb8dSv3asifkgfRjwvUl2ZkbHsZ1QsIDSuuYTjcPd4dNxRSru h+CFqLO8YQG2k01YFinsUrQoOD56s1rp5TSv2gDSaPACL1XYLxMq41/bbYd+8IDB 74bN8R+rCgapd8HnmtnmyKKsGa7tqJRWt4uihr1nGD7PPR6xJWO2jG9GAhzvgjfj wvsmYegO1jH7+Bu8dwToo5PiU/EtTKCzamwtPHMOur1D3Fe2yusOJ+YDYzkvkt36 AxHmXAQmNIVgYmf9BfgLlrdvDLtf6dBblr+PD5MS5lURxIL/fRkGn2mIrQwqV8Mj 2/lCA7mm4EyK2SkGSTZENBvR4SWv5FUZdrjOU1FFhyM3PtB7p8wz6C9MyXIzD8Bo GlAVpYTMfQVIWfcrw4E2HhPmugasKPgUSkvtZnhyKtg8NP7/6uQ= =d98m -----END PGP SIGNATURE----- --7lAF9h8SUnIEwJfu--