Re: After renaming a database the subscription ( logical replication) stay sticky to the old database (master)

To: Mai Peng <maily.peng@xxxxxxxxxxxxxxxxx>
Subject: Re: After renaming a database the subscription ( logical replication) stay sticky to the old database (master)
From: Peter Eisentraut <peter.eisentraut@xxxxxxxxxxxxxxx>
Date: Fri, 3 Jul 2020 08:11:48 +0200
Cc: pgsql-admin@xxxxxxxxxxxxxx, Yannick Le Guédart <yannick.le-guedart@xxxxxxxxxxxxxxxxx>
In-reply-to: <6773830B-F03E-4A8F-9EA9-58B78ABF984D@webedia-group.com>
Organization: 2ndQuadrant
References: <B62A5C5C-A627-487D-A132-930873704E30@webedia-group.com> <cbfc0551-0339-2a16-05b1-9a52a4fa4e5c@2ndquadrant.com> <6773830B-F03E-4A8F-9EA9-58B78ABF984D@webedia-group.com>
User-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1

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 wrongat first glance.


--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

References:
- After renaming a database the subscription ( logical replication) stay sticky to the old database (master)
  - From: Mai Peng
- Re: After renaming a database the subscription ( logical replication) stay sticky to the old database (master)
  - From: Peter Eisentraut
- Re: After renaming a database the subscription ( logical replication) stay sticky to the old database (master)
  - From: Mai Peng