Can't drop logical replication slot

From: Axel Rau <Axel(dot)Rau(at)chaos1(dot)de>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Can't drop logical replication slot
Date: 2021-09-28 20:55:22
Message-ID: CA952D9E-8408-4489-8C1B-FC914B6D80A4@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Axel Rau 2021-09-28 20:58:05 [FIXED] Re: Can't drop logical replication slot
Previous Message Scott Ribe 2021-09-27 14:39:34 Re: copy to program with format binary