RE: BUG #18789: logical replication slots are deleted after failovers

From: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
To: "sachinkonde3(at)gmail(dot)com" <sachinkonde3(at)gmail(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: BUG #18789: logical replication slots are deleted after failovers
Date: 2025-01-30 11:48:23
Message-ID: OSCPR01MB1496612E159D0EF49A50A3088F5E92@OSCPR01MB14966.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dear Sachin,
>
> We are using 2 node PostgreSQL 17 HA setup using Patroni 4.0.4.
> When I do failover 2nd or third time or more than once, it fails to transfer
> or move logical replication slot to new Primary.

For better understanding, can you clarify 1) network configuration you created
and 2) actual nodes queries were run?
Four instances are needed to do a failover third time, but not sure how they connected.

----------
Best regards,
Haato Kuroda

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Raghvendra Mishra 2025-01-30 16:29:41 Re: BUG #18790: Pg_stat_statements doesn't track schema.
Previous Message Stanley Pagenel 2025-01-30 10:46:54 RE: Trying to ugrade from version 16.2 to 17