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 1sTWZ6-00HAvq-OW for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Jul 2024 01:01:12 +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 1sTWZ4-00EPao-Ni for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Jul 2024 01:01:10 +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 1sTWZ4-00EPag-FB for pgsql-bugs@lists.postgresql.org; Tue, 16 Jul 2024 01:01:10 +0000 Received: from fhigh5-smtp.messagingengine.com ([103.168.172.156]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sTWZ1-002KDe-MH for pgsql-bugs@lists.postgresql.org; Tue, 16 Jul 2024 01:01:09 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 859D0114806D; Mon, 15 Jul 2024 21:01:05 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Mon, 15 Jul 2024 21:01:05 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= 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=fm2; t=1721091665; x=1721178065; bh=VeqMwUM3hf o+5R4S+kdaZINEJ4UG5+HU+VwixlHZ7r4=; b=rCtwcLN0uLcj5cFANhnBDK4tno PtXMkv2xDjGSsKcWKSMjC/svZqHqVE7XBcOyXZk0rTysmmtgoXLqHJgtokqHt+Cc xImWuq74kIejjXy81ZaIxjTQcD0VmtjBCgAqjsCSNZnkMHaW0NZPtALHOX3rJVZ8 PRBhezXsW/IvaD2psTv/+aF/NON+fh4eM7lFXRGUIoAheud3oY7/m7vcwCbUIjIF zYOQQDE5rsVA93qUJvmvSrso0hJ4qNbxuAGrffpzH081fiI9JjuP81t8/fvHh6wS WFk+rVNKhaYqZVf7Ij35bbwPaNGHAjBDLfoDJL/sOuieTVDesZMvHBdowdQg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1721091665; x=1721178065; bh=VeqMwUM3hfo+5R4S+kdaZINEJ4UG 5+HU+VwixlHZ7r4=; b=e2GlVGRbb70bcuXZyADI3mHZNNecpf1MZ9p/AaPtpXdd NeCsGx0QS2fuANUIQsmIDWC8LbTG4sz5R8f+xsdEjnq4hxxQyRysilxbsH+TCFwC 0JEB/0/e/QmkKaqFmFnm4mMjc+fSPS4a1tTrkjS86HX735ARNxWzd7nGHfutitmg 6c1SfQX4/3ubp5Hu6NVnU2Lj6/EEsLHKNkgaUradNla8B9mnEwsTWEzdY/AOAwwt sJixFdd0To7FszmjAOV8RdfvvKDmnTGqvwRt9CXfVQP1fPW7VEEwbxZ2/uYt7ZAQ /RhuGedle70YHOOcFc7cIwvdI5+6dlJh1Qa0//YgKQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrgeefgdegudcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnh epvdegudeuhfdtueeltedtveejheehieevueeigeelteegleejleeiueeiheegvefhnecu vehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrg gvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 15 Jul 2024 21:01:02 -0400 (EDT) Date: Tue, 16 Jul 2024 10:00:52 +0900 From: Michael Paquier To: jason.chentj@homecredit.cn, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18540: Does PG16 standby database support function pg_replication_origin_advance? Message-ID: References: <18540-eb48b78bd306c618@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="ElG/1sJydci9tzRc" Content-Disposition: inline In-Reply-To: <18540-eb48b78bd306c618@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --ElG/1sJydci9tzRc Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Jul 15, 2024 at 08:28:26AM +0000, PG Bug reporting form wrote: > Seems the function pg_replication_origin_advance is not supported running= on > standby instance. It there any workaround for it?=20 Not that I know of. One would need to study how to lift this restriction in place since the introduction of replication origins in 5aa2350426c4. -- Michael --ElG/1sJydci9tzRc Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmaVxkQACgkQnvQgOdby QH2U+w/8C89rfSYmnr8L/l33DEE+EX5AQm3mmX3VTfrEqW7zwx4SJNAQWRRrDZ6f tajG7wepl7/ELdHbjLwCqweNmCtRIhzEnI91gClkJIH9LnTFHTj79UxsmbK5Gj81 r5W46THR9vNvcWFDLBiZxc3Ta8Mx0iEGG5pyKxOk0Degb2QvxXfQc5JueVZpEZCI Gl95dNyP7DhybhknLa4r7q6Cc7lIHEZ8vKMeoSg2I9NIQttSOb4LIq0AStPU/27g goEnI2TPoRSh5N+P+gr3Q0lgw+egW4gKR0RH2Rej6w+mDxz42y2bchK5vE7/j1us AEEr7jugODIYN6pVWTAMaZNFiapgu8/wFAh7+FPDSjd5uGEXWYftiVOjhE2QHFrr 4icnMaYMulvD7c4kkmOXEeLpU+L0RLO6C7MA71lBzQzDocgKFR5xqwzqmNtA1p6X JPeP4La9Jla+vywfKp20JEVc57NMy2FnSiT1XXoxDC64/ejhTwaEUv4b2uQEcAHA vKnfGKQx33o7Mx9KooFdX4A87972LfU+pHXpLCAM35s/2vdXWZQKrBvAongnUdgp mIvxtSGvGvszVAHWGAffGgTg567m98LSaylV726SqGq2MZiAxziGPPwgrVxCXsbI o3llwwVK1E1HG3Qt4aKCRV1jmcW94TXM+XeOheUGUekSjI98yhU= =dWqM -----END PGP SIGNATURE----- --ElG/1sJydci9tzRc--