Have to disable and detach it first:
ALTER SUBSCRIPTION subscription DISABLE;ALTER SUBSCRIPTION subscription SET (slot_name = NONE);DROP SUBSCRIPTION subscription ;On Tue, Sep 28, 2021 at 4:58 PM Axel Rau <Axel.Rau@xxxxxxxxx> wrote:
I just noticed my typo:meteo_ddb4 != meteo_dbb4AxelAm 28.09.2021 um 22:55 schrieb Axel Rau <Axel.Rau@xxxxxxxxx>:Hi all,
while trying to setup a new logical replication with a master, which
was a physical replication slave (and is now a master), I get:
operations=# SELECT * FROM pg_replication_slots;
slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn
------------+----------+-----------+--------+------------+-----------+--------+------------+------+--------------+--------------+---------------------
meteo_ddb4 | pgoutput | logical | 18360 | operations | f | f | | | 180762192 | 2C2/6CB2FB50 | 2C2/6CB2FB88
meteo_ddb5 | pgoutput | logical | 18360 | operations | f | f | | | 180762192 | 2C2/6CB2FB88 | 2C2/6CB2FBC0
(2 rows)
Time: 2,435 ms
operations=# select * from pg_drop_replication_slot('meteo_dbb5');
ERROR: replication slot "meteo_dbb5" does not exist
Time: 1,556 ms
operations=#
How can I fix this?
Subscription on the other end has been dropped.
Any help appreciated,
Axel
---
PGP-Key: CDE74120 ☀ computing @ chaos claudius---
PGP-Key: CDE74120 ☀ computing @ chaos claudius
