Will there be data loss between slot syncronisation

From: Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Will there be data loss between slot syncronisation
Date: 2024-10-24 17:05:49
Message-ID: CAFpL5VyZNeT62hojHS-qnVrHzo6kRda-NxULdUcfX6KpX3HG+A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Claus Koch 2024-10-24 17:13:33 Re: Postgres capacity planning.
Previous Message Sbob 2024-10-24 16:53:20 Partitioned table scanning all pertitions when the where clause specifies the partition key