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 1r8xX4-00CuJr-12 for pgsql-docs@arkaria.postgresql.org; Fri, 01 Dec 2023 07:01:50 +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 1r8xX2-005qTy-Nj for pgsql-docs@arkaria.postgresql.org; Fri, 01 Dec 2023 07:01:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8xX1-005qTq-6m for pgsql-docs@lists.postgresql.org; Fri, 01 Dec 2023 07:01:48 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8xWw-009UlX-SF for pgsql-docs@lists.postgresql.org; Fri, 01 Dec 2023 07:01:46 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id AFD3E3200A6F; Fri, 1 Dec 2023 02:01:38 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Fri, 01 Dec 2023 02:01:38 -0500 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:sender :subject:subject:to:to; s=fm1; t=1701414098; x=1701500498; bh=3Z Wybs571GCXuvpc7cJjjD4POR6Ut70vcOWkCPHCqXY=; b=ItjOMJM7A44yawBXWd o6be+K9QlQdllwF8Ean0FTWm7ezoNdkS3p4/oBjINPHWDLlo5RIjTidrmVTl7Swb 9oWq8UMCH+bB2JdSEiHoJOLW5SR9YzJIlF9aJg69nPv5Ek2AFn8evpbym8LqMmbV ENF1AAOOslFZCJVBLiM1VtfuoEjaIP6Uo08bhrhGhjp7j/laqB/ULtugjB9RBeHY WynhA1joA4McijXsi+PyEWyBQiP29wYG2pGROHzdMADAr05psiLaIiIYQMEGOkWb +UOMRfBm2Wsl6gLCQS9EYpgGHGFW90BIkC4eaDZsuJNhpKtPwgYOAYwWXCNG9xx7 ucaw== 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:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; t=1701414098; x=1701500498; bh=3ZWybs571GCXu vpc7cJjjD4POR6Ut70vcOWkCPHCqXY=; b=jHxo8lxggiWqPsOPYD3b75ogVRTxc 9fn7X63TeBuBcftq00mvxdfw9yd90W/k8cT5iTzgvgEdeHjzZ3eDvWKvNh9gAQHv i3ED5suFMfOLqUQg8ucey2HCv/cRIIzlX20WDm1Kf4FVhpyjhggA3gCCHJYy/z13 beToWHWMWvTW1dFBobopyRtSr0zII7E6QO1BaPYx6D8BNRXffagcvBz8br3q/0se wC7KveSHq2B6PSmiP8q9k/cusfec/8ujGsFQNIx3SzVq9bKyroF74MJlm07NZJq0 /5mIdkfSFzm8hbMRTM701z6wkCcVIraIwKIWBPHnL75pFexiI9GDwuyBQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrudeikedgleelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 1 Dec 2023 02:01:36 -0500 (EST) Date: Fri, 1 Dec 2023 16:01:24 +0900 From: Michael Paquier To: Shinya Kato Cc: pgsql-docs@lists.postgresql.org Subject: Re: Delete description of trigger file Message-ID: References: <201b08ea29aa61f96162080e75be503c@oss.nttdata.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="vOL9Zo5Fa14IcTMT" Content-Disposition: inline In-Reply-To: <201b08ea29aa61f96162080e75be503c@oss.nttdata.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --vOL9Zo5Fa14IcTMT Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Dec 01, 2023 at 11:54:14AM +0900, Shinya Kato wrote: > later disconnected, the standby goes back to step 1 and tries to > restore the file from the archive again. This loop of retries from the > archive, pg_wal, and via streaming replication goes on until the server > - is stopped or failover is triggered by a trigger file. > + is stopped. Just removing this information looks incorrect to me, because a promotion would cause the retries to stop the WAL lookups. Shouldn't the last part of this sentence be reworded as of a "or is promoted"? -- Michael --vOL9Zo5Fa14IcTMT Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmVphMQACgkQnvQgOdby QH3PNxAAkvtF4CBcXm7mubgFKHdzqtsVsYi9TwB74KuEuqLDSKyuxKv3VfKdNqwG 74XCbFIAekQHEXXfZvOBvcdD6Mpb1J5vnfdvkqKxfLX3k7MH6+mmbxeqHyANLKQC QhTVToUZ6yWMnDPP/zfxfTz6kxznncQpK7A9lsW5DvNeA+c4WVyXg9ZCpGGBiFKR Cck14x/ze48hmdGlE4yCitzajo9mhPFEfmg/2zkOjA07Md1Akfn4bNLx6p/d1Ux5 qn6GVstC2JlnEW48lQKdS4FP5H5BTUKH2TJ4cI0++gsMdHqpMl7tI6HDh+BLpPKY 9xiMkPaPlpXmwrmTnYpOq9/KryyqHfP0mzTJbqPV8decpgulNEX04dMFEGUtGGt+ xGrdmIGGIBzcWSfHZtF+3fVe+LiEHGYycqNV6+l1v2BOnblBApTclcbW650lWG3i 2pD5+Kic/FXJFLLSMb2+9Mwg1zGz568Gtw2FMRX8i2WPyxHOwEjMdaaVNkhw8slV 5Bag1BiYryCPXmEw0kobpfkUoze+rWeM6yp9rwVhUauWt9ilQR0RycgJ6ZHZw/JS F3TbgjCY2tbwswxYNCQNcllRnbpY1mW2XcPS0F4vKxEXlVQHh59S13G1TnJwfU8J VNsv3flEUqAF+CJUykYk+yS/f6PlQNMFPk492Hx7EqJifemsxuY= =vFV+ -----END PGP SIGNATURE----- --vOL9Zo5Fa14IcTMT--