[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: BUG #17296: replication slot self-removed after created
From:       Masahiko Sawada <sawada.mshk () gmail ! com>
Date:       2021-12-10 6:06:11
Message-ID: CAD21AoB_yD9VcOAYR3ppu7qM0oEX69yfjviGFV=nq4W+g6MG+Q () mail ! gmail ! com
[Download RAW message or body]

On Mon, Nov 22, 2021 at 10:45 PM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      17296
> Logged by:          Anna
> Email address:      podkina@gmail.com
> PostgreSQL version: 12.8
> Operating system:   Oracle Linux Server release 8.4
> Description:
>
> Hello!
> I've met the problem with the cluster by patroni.
> Cluster configuration: 3 nodes, etcd downstairs.
> I tried to set up the Standby cluster through the replication slot as I did
> it before on the same version of patroni/PostgreSQL, but different OS and
> hardware environment.
> (not sure it's important)
>
> Anyway, I create the replication slot by the command (psql, locally on the
> host):
> SELECT pg_create_physical_replication_slot('patroni12_standby', true);
>
> Immediately after I see my slot in pg_replication_slots
> Then in a few seconds, there is no slot.

Other than temporary replication slots, as far as I know, there is no
functionality in PostgreSQL that automatically drops replication
slots. Given that you created the persistent replication slot
‘patroni12_standby', it's likely that other components in your system
dropped it. It might be a good idea to set log_statement = ‘all' and
log_replication_commands = ‘on' in order to identify who dropped the
replication slot.

Regards,

-- 
Masahiko Sawada
EDB:  https://www.enterprisedb.com/


[prev in list] [next in list] [prev in thread] [next in thread]