public inbox for [email protected]  

help / color / mirror / Atom feed

Will there be data loss between slot syncronisation
2+ messages / 2 participants
[nested] [flat]

* Will there be data loss between slot syncronisation
@ 2024-10-24 17:05  Nikhil Shetty <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Nikhil Shetty @ 2024-10-24 17:05 UTC (permalink / raw)
  To: Pgsql-admin <[email protected]>

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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Will there be data loss between slot syncronisation
@ 2024-10-25 04:31  Muhammad Usman Khan <[email protected]>
  parent: Nikhil Shetty <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Muhammad Usman Khan @ 2024-10-25 04:31 UTC (permalink / raw)
  To: Nikhil Shetty <[email protected]>; +Cc: Pgsql-admin <[email protected]>

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 <[email protected]> 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
>


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-10-25 04:31 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-24 17:05 Will there be data loss between slot syncronisation Nikhil Shetty <[email protected]>
2024-10-25 04:31 ` Muhammad Usman Khan <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox