Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqTFp-0002kI-KG for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Feb 2019 01:40:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gqTFm-0001Lg-AM for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Feb 2019 01:40:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqTFm-0001LZ-3N for pgsql-hackers@lists.postgresql.org; Mon, 04 Feb 2019 01:40:54 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqTFf-00032m-TT for pgsql-hackers@postgresql.org; Mon, 04 Feb 2019 01:40:53 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 07E6521E44; Sun, 3 Feb 2019 20:40:46 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Sun, 03 Feb 2019 20:40:46 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=YW+Ge7KrTTYw18IgLYFBLpHBawm 0dHCZFnohjMnfqE4=; b=Jpjl2l+XTEyGWEg4e7vnENkEZBChljHwDLaHwOEbpVV CKTx4YdRHPLd88gtsl/LMqZD2SlZd1E5XVYsuyp/DOOMpRQUyTfyKe0xlS8pdhBB AnOrK+7edmQEKP7PfpKvMSYFysvTzRQ1FpRAc6zJcTy9KooB9QYuHMEhUbF3DlmQ H0CWg1XqbQsFlXiQ0epa1oUmVl7aAOxixO2K3+CT5QDkAYZ2VVf5D/gyO8i2v4CT mQWyMy9YbAd0HXn9Y/qZAt7yI/lg/MWcrCVQ2iZwbqr2mJaPsmMmuLkTNrFlPQDk UVoz4J6Xx7TS+Fq7h8howIxxBwzh9KDWoV3uPJzU8xA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=YW+Ge7 KrTTYw18IgLYFBLpHBawm0dHCZFnohjMnfqE4=; b=jjmKVdqHUifVMrUfaiwyXr Pp1a3rnVbp25kO6olJTMBE4PZ6b4rOqLFNKxTO9KlsyhTm3eJQYjxJXZHmEiV9Oj FkWSgqzgeNgOsJmxof9+IOTzhfg4QmTYAKH3+rK9UMu/vc13ZHrIkXSvpl/xSccW XsTCIL57kjqHcvVmtn/3EEWqXsJlWxQZmKL6TCvjoHtdNfhVMgyLjfCz+2YQUAhu 84FmOhDliWEVNr2PLJcBUz9jnpAlergbPwpM0Z5q4fQQqGvpRgI5h40WQsuAuEo+ 5VHmEj4Z05sBRWB2R8ZNWbnJZ1L4e0uRGB6RXeGnkpEaNzw428ihuluWPrGjx8/g == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtledrkeefgdefiecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfhuthenuceurghilhhouhhtmecufedt tdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrhhlucfvnfffucdljedtmd enucfjughrpeffhffvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghh rggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenuc fkphepuddukedrvdeguddrvdehtddrvddvheenucfrrghrrghmpehmrghilhhfrhhomhep mhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (mp76f1fae1.ap.nuro.jp [118.241.250.225]) by mail.messagingengine.com (Postfix) with ESMTPA id D18B710087; Sun, 3 Feb 2019 20:40:42 -0500 (EST) Date: Mon, 4 Feb 2019 10:40:40 +0900 From: Michael Paquier To: "Tsunakawa, Takayuki" Cc: 'Haribabu Kommi' , Laurenz Albe , Tom Lane , Dave Cramer , Robert Haas , Jing Wang , PostgreSQL-development Subject: Re: Libpq support to connect to standby server as priority Message-ID: <20190204014040.GD1881@paquier.xyz> References: <26251.1547504236@sss.pgh.pa.us> <0A3221C70F24FB45833433255569204D1FB67687@G01JPEXMBYT05> <0A3221C70F24FB45833433255569204D1FB69730@G01JPEXMBYT05> <0A3221C70F24FB45833433255569204D1FB6990A@G01JPEXMBYT05> <0A3221C70F24FB45833433255569204D1FB69945@G01JPEXMBYT05> <0A3221C70F24FB45833433255569204D1FB6C737@G01JPEXMBYT05> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="jL2BoiuKMElzg3CS" Content-Disposition: inline In-Reply-To: <0A3221C70F24FB45833433255569204D1FB6C737@G01JPEXMBYT05> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --jL2BoiuKMElzg3CS Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Jan 21, 2019 at 06:48:14AM +0000, Tsunakawa, Takayuki wrote: > That would be fine. But as I mentioned in another mail, I think > "get read-only session" and "connect to standby" differ. So I find > it better to separate parameters for those request; > target_session_attr and target_server_type.=20 We've had plenty of discussions about this patch, and nothing really got out of the crowd. For now I am marking the patch as returned with feedback as it has been marked as waiting on author for two weeks now. It may be worth continuing the discussion, still we need to come up with an agreement first. -- Michael --jL2BoiuKMElzg3CS Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlxXmBgACgkQnvQgOdby QH0amBAAgcg1ZvDBnV0CwDZl70k2eNdPCFrVQnRx23AhI6BMLKHSRXr/FMAnOZ0F TYfzVL5Vj6DeysuTXh7qORT+PLpzzfbjfg8qTlh1Y3B9eP6cRsRxB/Xf5wz+F4pE 4iECOJVvkxM+6JhLCqPomwWJzuG2sM3DsNiglubaalXXd753c9PnUf/93QnG+yfZ zH9EEnOGrvN0pr3t2fxaQDlKHwDhQqAQ5x/KpQI0U5/nYZTPVhDW6kRpiwtAZ+Yi uBVYNzLDN0LFhOB/Bn7x9jF7uPn3zedY+vubTZsLThMewi1b3bII4CALOXvdb5R5 Z8YM7/Im7ficOShjYjBaMH1tkDzV5n/HQvY0I3Cb9VZYFEL7JxqL5WuiRxM1VgY/ YK7IIvx9Hc5hvHItIWKrCqivp7zd34JiRX3C8zZDAuu9OKkt6fYxcgrYYNLcTG/N UT+EfrLqLsOLw2/aR/LMreo7RAdtqRD0iY8OQtP348rXjI78Jw0kdG/3VgJ2hD/Q 7asmnKi5FWTPRT5gBZDfiv/LIaZs2NNq7DrDw44xHrkLeHsRjR21zjrnETk5zzvx KgOVGiAGxc3c85e7Kwc+ujneiMpFMBeCpQBmc8zgykdnnkJTghFzC9HxNanKUO62 5zMaetoUGkVVoHAIYXkQAtIPfZLAgsFLB0SHNHSlvdwJPxUfIM4= =OiPP -----END PGP SIGNATURE----- --jL2BoiuKMElzg3CS--