Re: [FIXED] Re: Can't drop logical replication slot

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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_dbb4

Axel

Am 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


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux