Re: Will there be data loss between slot syncronisation - Mailing list pgsql-admin

From Muhammad Usman Khan
Subject Re: Will there be data loss between slot syncronisation
Date
Msg-id CAPnRvGv13EDy1m9fLpG8snO7xHim0Ti3D6fdajZDf8DnvUvwTQ@mail.gmail.com
Whole thread Raw
In response to Will there be data loss between slot syncronisation  (Nikhil Shetty <nikhil.dba04@gmail.com>)
List pgsql-admin
Hi,
Data loss may occur because unsynced slots may not have fully replicated all the necessary changes from the primary.


On Thu, 24 Oct 2024 at 22:06, Nikhil Shetty <nikhil.dba04@gmail.com> wrote:
Hi Team,

As per documentation for sync_replication_slots:

The nap time of the worker is tuned according to the activity on the
primary. The slot sync worker waits for some time before the next
synchronization, with the duration varying based on whether any slots were
updated during the last cycle.

What happens if there is a long period where the standby slot is not synced and there is autofailover? Will there be a data loss?

Thanks,
Nikhil

pgsql-admin by date:

Previous
From: Sbob
Date:
Subject: Re: Partitioned table scanning all pertitions when the where clause specifies the partition key
Next
From: Erik Serrano
Date:
Subject: PostgreSQL historical database