Обсуждение: Can't drop logical replication slot

Поиск
Список
Период
Сортировка

Can't drop logical replication slot

От
Axel Rau
Дата:
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
Вложения

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

От
Axel Rau
Дата:
I just noticed my typo:

meteo_ddb4 != meteo_dbb4

Axel

Am 28.09.2021 um 22:55 schrieb Axel Rau <Axel.Rau@chaos1.de>:

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

Вложения

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

От
Tim
Дата:
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@chaos1.de> wrote:
I just noticed my typo:

meteo_ddb4 != meteo_dbb4

Axel

Am 28.09.2021 um 22:55 schrieb Axel Rau <Axel.Rau@chaos1.de>:

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

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

От
Axel Rau
Дата:


Am 29.09.2021 um 14:34 schrieb Tim <timfosho@gmail.com>:

Have to disable and detach it first:

Yes, that was exactly what I did after fixing the typo.

Thanks, Axel
---
PGP-Key: CDE74120  ☀  computing @ chaos claudius

Вложения