From: | Tim <timfosho(at)gmail(dot)com> |
---|---|
To: | Axel Rau <Axel(dot)Rau(at)chaos1(dot)de> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: [FIXED] Re: Can't drop logical replication slot |
Date: | 2021-09-29 12:34:10 |
Message-ID: | CAKhLO5ij_KdB4=w=MFO=fvqhbFu09fz6AMDH4n9m+vX5npyMRg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)Rau(at)chaos1(dot)de> wrote:
> I just noticed my typo:
>
> meteo_ddb4 != meteo_dbb4
>
> Axel
>
> Am 28.09.2021 um 22:55 schrieb Axel Rau <Axel(dot)Rau(at)chaos1(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Axel Rau | 2021-09-29 13:37:22 | Re: [FIXED] Can't drop logical replication slot |
Previous Message | Sindhu S | 2021-09-29 05:13:48 | Re: reg running in server mode with automatic login |