public inbox for [email protected]  

help / color / mirror / Atom feed

From: Nikhil Shetty <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Will there be data loss between slot syncronisation
Date: Thu, 24 Oct 2024 22:35:49 +0530
Message-ID: <CAFpL5VyZNeT62hojHS-qnVrHzo6kRda-NxULdUcfX6KpX3HG+A@mail.gmail.com> (raw)

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

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Will there be data loss between slot syncronisation
  In-Reply-To: <CAFpL5VyZNeT62hojHS-qnVrHzo6kRda-NxULdUcfX6KpX3HG+A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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