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 1qOpHz-0096dc-PQ for pgsql-general@arkaria.postgresql.org; Thu, 27 Jul 2023 00:55:36 +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 1qOpHx-006uV0-IK for pgsql-general@arkaria.postgresql.org; Thu, 27 Jul 2023 00:55:33 +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 1qOpHv-006uUs-P4 for pgsql-general@lists.postgresql.org; Thu, 27 Jul 2023 00:55:33 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qOpHq-000ZrM-RT for pgsql-general@postgresql.org; Thu, 27 Jul 2023 00:55:31 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.west.internal (Postfix) with ESMTP id EE8EF3200905; Wed, 26 Jul 2023 20:55:22 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Wed, 26 Jul 2023 20:55:23 -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:sender :subject:subject:to:to; s=fm3; t=1690419322; x=1690505722; bh=ZW Y9L20HjMIvaZ1WPaP2o7Li+rBgbjxEBErFplyzA5w=; b=DIFFtIAySc5F9GSbk8 KqzZVKBa2uItIBB5KRHglelgA+EsyB0sxMsjVceIVErGDyLdODy2l+bEvdHf0qZz bANQZeZi3sRsg4AqIYteL4AmG3t+CB9X1x2IljKGqJQMY1mkvZxiWdNcvl+Ti2Fo M6j1GANfYosHx9vYM9WMFLOZI2PplUXqsUSSSN2CrFJ7yCZWqq484OKpsLLNfgcb NZXf+uCrQw0nwMsmobQKvdyyp84jy5WePgMcTAeSXP5HDwSafoMI1CjoyjcJRTTe 4USNxeKYuRwArRzvML5dBQL6tI9/g3r8k8BzOJO59Gz9AHewHx3+XzbC9dfpE1KB mzmw== 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=fm3; t=1690419322; x=1690505722; bh=ZWY9L20HjMIva Z1WPaP2o7Li+rBgbjxEBErFplyzA5w=; b=nqtJPCqI5ZBFMuUEGqW9zPRcSluHA 7fY+fTPFkxa19lp0bEcWJXdEdQd/WjuyJC2giLs8XzEjqnqOZLZwvcM8U+WtRFHm bQcFhUb86kd/QiaOGibW9sq7QTnGnbFEBNnjZF9p6lNn0VTXwJ9OfrPzR07v8CNA z/J24wZF5usnCVltI23jU5ahkdi3w7FLB/CAUS3c9e0YSBWOLtXf7oiZPeD6r/fK D/94YGxjoPloHFNEWWEFOASYxfVF9kzTkACAfCXGT7Asjs5Oo+zc7aXEiwMJIpJI +EXv0OkMh62osg3iAQtojAnYlr56zE/yJqSWuweRFGmWYaZrjQLhslUbw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrieefgdeflecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeg geffhfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 26 Jul 2023 20:55:21 -0400 (EDT) Date: Thu, 27 Jul 2023 09:55:17 +0900 From: Michael Paquier To: Praneel Devisetty Cc: pgsql-general@postgresql.org Subject: Re: Query on Primary_conninfo Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="815UAtelDU/spCNj" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --815UAtelDU/spCNj Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jul 26, 2023 at 05:33:50PM +0530, Praneel Devisetty wrote: > Standy is not picking this change even after a reload. >=20 > Restarting standby is working out, but as PG13 supports reload of > primary_connfino is there a reliable way to achieve this without restarti= ng > standby database. primary_conninfo should be able to switch dynamically the upstream server it streams WAL from on a reload. I've quickly checked with a simple configuration and I was able to get it done without a restart here. Perhaps you have found a bug, but it's hard to say without having more details about what's happening. For example, what do the logs of the standby tell you? Are you sure that the reload was done on the correct node? Did you check with a SHOW command that the new value is reflected on your standby to what you want it to be? -- Michael --815UAtelDU/spCNj Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmTBwHUACgkQnvQgOdby QH3nGg//cLP85NLyoW0TuERJzh8G61QaqzXnMK5+1TcqOncwRxNGApF49CgEbJhL O/TBoAzHvhc8+J5GKrY/cVRXdBozWbUl9C6l2g3QXEnCwvFAsrN4b5PTAKPszet7 qC8cnW7qV4hBwXfxohFMpDtZT+7yPDTH5JRRrvSd7KgdJd8UE0ZcxSknMk9Na3hG 4ghytC2U9oRUjIBu8jMBHK/8e0t+Hf2gEYTYCjDn0JhY/Jw9JF5SH7IkI5fhl/Wq BNz8kL/8FttUDuLlAznzGi3HKnsmIFdzWNrG86YfdWWGSmNk0tCBaF9LkwQsdYcu b1DqV2GIc1U4WIFAOlig7X8b/9nXLouDdNFLH6//A/9tGXNLgxNExou18tBokV5p gOKH1bJHm5pW6SZcVX8XhJAZT0NU2vIeXVvxZ4NVEDs+bHU0ikeTHA++m7mjpN2v 5yWL4I6CW/S0UISj+rSVZ9yi6u+YauhPnZTFMPQ66nmJdfTTv2++01QfkKRAOccV U6Hd6bdchOQXeDo8HsY0EbfJDyk3Iq9DZksPOFM5JGEIK/m8Eso6tUMF8B2Ir2mT zoY1Xcw3jt9dK+Cr6NuyHBEBhpdYJuA6cfZ4a/uJddHie3ix9PdJZ5YxZJ67x2AP uWSpBg+FFDtA5xNa1UzDqSmwZzGni9HsWlUgNOfBWqVIs2qPp4c= =hptv -----END PGP SIGNATURE----- --815UAtelDU/spCNj--