On Fri, Jun 13, 2025 at 9:46 PM Amit Kapila wrote:
> On Fri, Jun 13, 2025 at 10:52 PM Perumal Raj wrote:
> >
> > Thanks for explanation Shveta!
> >
> >
> > As Summary in this original thread,
> >
> > Prerequisites for Setting Up a Logical Replication Slot sync in >= pg17
> >
> > To
On Fri, Jun 13, 2025 at 10:52 PM Perumal Raj wrote:
>
> Thanks for explanation Shveta!
>
>
> As Summary in this original thread,
>
> Prerequisites for Setting Up a Logical Replication Slot sync in >= pg17
>
> To successfully configure a logical replication slot, ensure the following
Thanks for explanation Shveta!
*As Summary in this original thread,*
1.
*Prerequisites for Setting Up a Logical Replication Slot sync in >= pg17*
To successfully configure a logical replication slot, ensure the
following settings are applied:
wal_level = 'logical'
On Fri, Jun 13, 2025 at 1:00 PM Perumal Raj wrote:
>
> Yes Shveta!
>
> I could see repeated message in New-replica .
>
> 2025-06-13 06:20:30.146 UTC [277861] LOG: could not synchronize replication
> slot "kafka_logical_slot" because remote slot precedes local slot
> 2025-06-13 06:20:30.146 UTC [
Yes Shveta!
I could see repeated message in New-replica .
2025-06-13 06:20:30.146 UTC [277861] LOG: could not synchronize
replication slot "kafka_logical_slot" because remote slot precedes local
slot
2025-06-13 06:20:30.146 UTC [277861] DETAIL: The remote slot has LSN
0/6DB8 and catalog xmi
On Fri, Jun 13, 2025 at 6:23 AM Perumal Raj wrote:
>
> Hi Hou zj
>
> I have found some strange issue , but not sure if I am doing anything wrong.
>
> I am able to see logical slot at STANDBY even after promote. 👏
Good to know.
>
> Importantly Logical replication slot is persistance in STANDBYs w
Hi Hou zj
I have found some strange issue , but not sure if I am doing anything wrong.
*I am able to see logical slot at STANDBY even after promote. 👏*
Importantly Logical replication slot is persistance in STANDBYs which
already established connection with Primary before logical replication slo
On Thu, Jun 12, 2025 at 4:08 PM Perumal Raj wrote:
> Hi Community,
>
> I have installed postgres version 17.5 with following setup,
>
> Primary
>-- Secondary A
>-- Secondary B
> -- Secondary C
>
> Config:
> wal_level = 'logical'
> max_wal_senders = '10'
> max
Hi Community,
I have installed postgres version 17.5 with following setup,
*Primary *
-- Secondary A
-- Secondary B
-- Secondary C
*Config:*
wal_level = 'logical'
max_wal_senders = '10'
max_replication_slots = '10'
wal_keep_size = '512MB'
hot_standby = 'on'
sync_re
