Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJdxd-00045X-PR for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2020 14:03:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJdxc-0002Lw-NQ for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2020 14:03:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJdxc-0002KF-GT for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2020 14:03:16 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJdxW-0005Cb-Ep for pgsql-hackers@postgresql.org; Wed, 01 Apr 2020 14:03:15 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 570EE5C036A; Wed, 1 Apr 2020 10:03:09 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Wed, 01 Apr 2020 10:03:09 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding: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=fm2; bh=A/UQIuktOythCI8CU1p6KYl/yhq9JULXeZHm0qq88 ys=; b=w3BPuHs73a33jc65EErLIeVBly0E9F4jMcBVQIGq0Ee3cCL5ZpALWuNsF VJxT2/gGWCBDmp8iriVWP7xWzKcq8L4uaOqcAsfWd+S7qu06lBOH9IfEhwK03O6L Pr2GNddxrGktbvEN+Dv9KEiztyMpsLIr9HMU/jfAhK1dsSjqLvieyonC7LVGGxEH S2kJfJU02j0muRBjPakqrnPKiC9LZmV1PWbMo8ZLTn8g+fhzdASfU1mZRPsZD1+t wehAbGIDCrwH46i2bd8QwyfSfZlUC7py+y0U1+8RfTsIWIxR0vBKU2/FhxI1SOAv jK28p26OBlaUf/QuFIimqMhTfl2pw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduhedrtddvgdejudcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefuvfhfhfhokffffgggjggtgfesthejredttdefjeenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsedvnhguqh hurggurhgrnhhtrdgtohhmqeenucffohhmrghinhepvdhnughquhgrughrrghnthdrtgho mhenucfkphepleefrddvgedvrddvudefrddvgedunecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghishgvnhhtrhgruhhtsedv nhguqhhurggurhgrnhhtrdgtohhm X-ME-Proxy: Received: from april.pezone.net (p5df2d5f1.dip0.t-ipconnect.de [93.242.213.241]) by mail.messagingengine.com (Postfix) with ESMTPA id 70FA2306CCC4; Wed, 1 Apr 2020 10:03:06 -0400 (EDT) Subject: Re: allow online change primary_conninfo To: Sergei Kornilov , Alvaro Herrera References: <20200327195149.GA32145@alvherre.pgsql> <20200327233911.GA30735@alvherre.pgsql> <3109511585392143@myt6-887fb48a9c29.qloud-c.yandex.net> Cc: Michael Paquier , Tomas Vondra , Kyotaro Horiguchi , "andres@anarazel.de" , "david@pgmasters.net" , "pgsql-hackers@postgresql.org" From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <4b1bfe72-43ab-60ca-5b29-afc23f1726e7@2ndquadrant.com> Date: Wed, 1 Apr 2020 16:03:05 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <3109511585392143@myt6-887fb48a9c29.qloud-c.yandex.net> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-03-28 11:49, Sergei Kornilov wrote: > I attached updated patch: walreceiver will use configured primary_slot_name as temporary slot name if wal_receiver_create_temp_slot is enabled. The original setup worked consistently with pg_basebackup. In pg_basebackup, if you specify -S/--slot, then it uses a permanent slot with the given name. This is the same behavior as primary_slot_name has now. We should be careful that we don't create two sets of options/settings that look similar but combine in different ways. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services