Postgres Pro
Downloads
Home   >   mailing lists

couldn't drop subscription after upgrading via logical replication. - Mailing list pgsql-general

From James(王旭)
Subject couldn't drop subscription after upgrading via logical replication.
Date
Msg-id tencent_269B11641092C5FD07561477@qq.com
Whole thread Raw
List pgsql-general
Tree view
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:  could not drop the replication slot "sub_upgrade_to_13" on publisher
DETAIL:  The error was: ERROR:  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!

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL License Question
Next
From: Hemil Ruparel
Date:
Subject: Re: Best tools to monitor and fine tune postgres