Re: synchronized_standby_slots used in logical replication

2025-06-06 Thread shveta malik
On Thu, Jun 5, 2025 at 3:10 PM Fabrice Chapuis wrote: > > Thank you very much for the detailed response. I will proceed with the native > implementation for synchronizing logical replication slots. Sure, thanks! > In a maintenance context, when standby is shutdown, it's possible to > temporar

Re: synchronized_standby_slots used in logical replication

2025-06-05 Thread Fabrice Chapuis
Thank you very much for the detailed response. I will proceed with the native implementation for synchronizing logical replication slots. In a maintenance context, when standby is shutdown, it's possible to temporarily disable the synchronized_standby_slots parameter to avoid blocking logical repl

Re: synchronized_standby_slots used in logical replication

2025-06-05 Thread shveta malik
On Wed, Jun 4, 2025 at 4:01 PM Fabrice Chapuis wrote: > > Hi, > > I'm working with logical replication in a PostgreSQL 17 setup, and I'm > exploring the new synchronized_standby_slots parameter to make replication > slots failover safe in a highly available environment using physical standby >

synchronized_standby_slots used in logical replication

2025-06-04 Thread Fabrice Chapuis
Hi, I'm working with *logical replication* in a PostgreSQL 17 setup, and I'm exploring the new synchronized_standby_slots parameter to make replication slots failover safe in a highly available environment using physical standby nodes managed by Patroni. While testing this feature, I encountered