couldn't drop subscription after upgrading via logical replication.

From: James(王旭) <wangxu(at)gu360(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: couldn't drop subscription after upgrading via logical replication.
Date: 2021-01-16 01:43:11
Message-ID: tencent_269B11641092C5FD07561477@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I upgraded my postgres from 11 to 13 using logical replication(publication in PG-11 and subscription in PG-13 of course).

Now I encountered this problem, I cannot drop the subscription in PG-13:
drop subscription sub_upgrade_to_13;
ERROR:&nbsp; could not drop the replication slot "sub_upgrade_to_13" on publisher
DETAIL:&nbsp; The error was: ERROR:&nbsp; replication slot "sub_upgrade_to_13" does not exist
The thing is that I already stoped my PG-11, there's no way I drop the replication slot "sub_upgrade_to_13" on publisher,
is there anything I can do to solve it?

Many thanks!

Browse pgsql-general by date

  From Date Subject
Next Message Hemil Ruparel 2021-01-16 05:01:00 Re: Best tools to monitor and fine tune postgres
Previous Message Adrian Klaver 2021-01-16 00:03:17 Re: PostgreSQL License Question