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 1jrEvV-0008TE-Ji for pgsql-admin@arkaria.postgresql.org; Fri, 03 Jul 2020 06:11:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jrEvU-0007vw-Fd for pgsql-admin@arkaria.postgresql.org; Fri, 03 Jul 2020 06:11:56 +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 1jrEvT-0007vp-EI for pgsql-admin@lists.postgresql.org; Fri, 03 Jul 2020 06:11:56 +0000 Received: from forward3-smtp.messagingengine.com ([66.111.4.237]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jrEvQ-0007KX-K8 for pgsql-admin@postgresql.org; Fri, 03 Jul 2020 06:11:54 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailforward.nyi.internal (Postfix) with ESMTP id 471421940799; Fri, 3 Jul 2020 02:11:51 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Fri, 03 Jul 2020 02:11:51 -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=fm3; bh=cjT1AUUgl24lGHYyEuhNS1+byzGkfhLzFY5hQbDzo CA=; b=rmUGwdO4JStahDzCNZrxkZlh+hmF6raVfjMC1ASlPeH3u2xXGiufCH+JD x+M1iLl+tavv+tGeDSibI+RPnLj5ClAhigYJ882xh3MBOs4nYUIrxvHXNcTyAsL1 XVpKCVld9I0p6LiLAlqXmf6t/aB2T9yh8dl7Hsm9P++JlfguLYTN7L12pMM7SPGM 1JOEP2hbj76TJ2xhi8OpwSE5lnIva9hkLsR/ocpsRyopqgK/iId1WVuwfbnJssrH IizrqCJR5pLOZdFKT3ThgjGW8HWNWDnk4o+o9NPlz6hU9Mxf+W4iyRFKjbhYhrIj CHr7ta9fre/LB75OyVWXtrUfpbBjQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduiedrtdehgddutdegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhohfkffgfgggjtgfgsehtjeertddtfeejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvdhnug hquhgrughrrghnthdrtghomheqnecuggftrfgrthhtvghrnheptdevgeehtdejvdevvdel jeeuveejjedtleelgfekleefieekjeelgfektdduuedvnecuffhomhgrihhnpedvnhguqh hurggurhgrnhhtrdgtohhmnecukfhppeelfedrvdegfedrudeluddrvdefkeenucevlhhu shhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrrdgvih hsvghnthhrrghuthesvdhnughquhgrughrrghnthdrtghomh X-ME-Proxy: Received: from april.pezone.net (p5df3bfee.dip0.t-ipconnect.de [93.243.191.238]) by mail.messagingengine.com (Postfix) with ESMTPA id 427C83060061; Fri, 3 Jul 2020 02:11:50 -0400 (EDT) Subject: Re: After renaming a database the subscription ( logical replication) stay sticky to the old database (master) To: Mai Peng References: <6773830B-F03E-4A8F-9EA9-58B78ABF984D@webedia-group.com> Cc: pgsql-admin@postgresql.org, =?UTF-8?Q?Yannick_Le_Gu=c3=a9dart?= From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: Date: Fri, 3 Jul 2020 08:11:48 +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: <6773830B-F03E-4A8F-9EA9-58B78ABF984D@webedia-group.com> 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-07-01 11:01, Mai Peng wrote: > Hello Peter, > Here the script: But you didn't describe what the problem is. I don't see anything wrong at first glance. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services