MIME-Version: 1.0
From: Nikhil Shetty <nikhil.dba04@gmail.com>
Date: Thu, 24 Oct 2024 22:35:49 +0530
Message-ID: 
 <CAFpL5VyZNeT62hojHS-qnVrHzo6kRda-NxULdUcfX6KpX3HG+A@mail.gmail.com>
Subject: Will there be data loss between slot syncronisation
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004a7e5406253c0451"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFpL5VyZNeT62hojHS-qnVrHzo6kRda-NxULdUcfX6KpX3HG%2BA%40mail.gmail.com>
Precedence: bulk

--0000000000004a7e5406253c0451
Content-Type: text/plain; charset="UTF-8"

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

--0000000000004a7e5406253c0451
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Team,<div><br></div><div>As per documentation for=C2=A0=
<span style=3D"color:rgb(0,0,0);font-family:monospace">sync_replication_slo=
ts:</span></div><div><br></div><div><span style=3D"color:rgb(0,0,0);font-fa=
mily:monospace">The=C2=A0nap=C2=A0time=C2=A0of=C2=A0the=C2=A0worker=C2=A0is=
=C2=A0tuned=C2=A0according=C2=A0to=C2=A0the=C2=A0activity=C2=A0on=C2=A0the<=
/span><br style=3D"color:rgb(0,0,0);font-family:monospace"><span style=3D"c=
olor:rgb(0,0,0);font-family:monospace">primary.=C2=A0The=C2=A0slot=C2=A0syn=
c=C2=A0worker=C2=A0waits=C2=A0for=C2=A0some=C2=A0time=C2=A0before=C2=A0the=
=C2=A0next</span><br style=3D"color:rgb(0,0,0);font-family:monospace"><span=
 style=3D"color:rgb(0,0,0);font-family:monospace">synchronization,=C2=A0wit=
h=C2=A0the=C2=A0duration=C2=A0varying=C2=A0based=C2=A0on=C2=A0whether=C2=A0=
any=C2=A0slots=C2=A0were</span><br style=3D"color:rgb(0,0,0);font-family:mo=
nospace"><span style=3D"color:rgb(0,0,0);font-family:monospace">updated=C2=
=A0during=C2=A0the=C2=A0last=C2=A0cycle.</span><br></div><div><span style=
=3D"color:rgb(0,0,0);font-family:monospace"><br></span></div><div><span sty=
le=3D"color:rgb(0,0,0)"><font face=3D"arial, sans-serif">What happens if th=
ere is a long period where the standby slot is not synced and there is auto=
failover? Will there be a data loss?</font></span></div><div><span style=3D=
"color:rgb(0,0,0)"><font face=3D"arial, sans-serif"><br></font></span></div=
><div><span style=3D"color:rgb(0,0,0)"><font face=3D"arial, sans-serif">Tha=
nks,</font></span></div><div><span style=3D"color:rgb(0,0,0)"><font face=3D=
"arial, sans-serif">Nikhil</font></span></div></div>

--0000000000004a7e5406253c0451--