MIME-Version: 1.0
References: 
 <CAFpL5VyZNeT62hojHS-qnVrHzo6kRda-NxULdUcfX6KpX3HG+A@mail.gmail.com>
In-Reply-To: 
 <CAFpL5VyZNeT62hojHS-qnVrHzo6kRda-NxULdUcfX6KpX3HG+A@mail.gmail.com>
From: Muhammad Usman Khan <usman.k@bitnine.net>
Date: Fri, 25 Oct 2024 09:31:06 +0500
Message-ID: 
 <CAPnRvGv13EDy1m9fLpG8snO7xHim0Ti3D6fdajZDf8DnvUvwTQ@mail.gmail.com>
Subject: Re: Will there be data loss between slot syncronisation
To: Nikhil Shetty <nikhil.dba04@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001562d30625459753"
Archived-At: 
 <https://www.postgresql.org/message-id/CAPnRvGv13EDy1m9fLpG8snO7xHim0Ti3D6fdajZDf8DnvUvwTQ%40mail.gmail.com>
Precedence: bulk

--0000000000001562d30625459753
Content-Type: text/plain; charset="UTF-8"

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
>

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

<div dir=3D"ltr"><div><div dir=3D"ltr" class=3D"gmail_signature" data-smart=
mail=3D"gmail_signature"><div dir=3D"ltr"><div>Hi,<br>Data loss may occur b=
ecause unsynced slots may not have fully replicated all the necessary chang=
es from the primary.</div></div></div></div><br></div><br><div class=3D"gma=
il_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, 24 Oct 2024 at 22:0=
6, Nikhil Shetty &lt;<a href=3D"mailto:nikhil.dba04@gmail.com">nikhil.dba04=
@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div dir=3D"ltr">Hi Team,<div><br></div><div>As per documentatio=
n for=C2=A0<span style=3D"color:rgb(0,0,0);font-family:monospace">sync_repl=
ication_slots:</span></div><div><br></div><div><span style=3D"color:rgb(0,0=
,0);font-family:monospace">The=C2=A0nap=C2=A0time=C2=A0of=C2=A0the=C2=A0wor=
ker=C2=A0is=C2=A0tuned=C2=A0according=C2=A0to=C2=A0the=C2=A0activity=C2=A0o=
n=C2=A0the</span><br style=3D"color:rgb(0,0,0);font-family:monospace"><span=
 style=3D"color:rgb(0,0,0);font-family:monospace">primary.=C2=A0The=C2=A0sl=
ot=C2=A0sync=C2=A0worker=C2=A0waits=C2=A0for=C2=A0some=C2=A0time=C2=A0befor=
e=C2=A0the=C2=A0next</span><br style=3D"color:rgb(0,0,0);font-family:monosp=
ace"><span style=3D"color:rgb(0,0,0);font-family:monospace">synchronization=
,=C2=A0with=C2=A0the=C2=A0duration=C2=A0varying=C2=A0based=C2=A0on=C2=A0whe=
ther=C2=A0any=C2=A0slots=C2=A0were</span><br style=3D"color:rgb(0,0,0);font=
-family:monospace"><span style=3D"color:rgb(0,0,0);font-family:monospace">u=
pdated=C2=A0during=C2=A0the=C2=A0last=C2=A0cycle.</span><br></div><div><spa=
n style=3D"color:rgb(0,0,0);font-family:monospace"><br></span></div><div><s=
pan style=3D"color:rgb(0,0,0)"><font face=3D"arial, sans-serif">What happen=
s if there is a long period where the standby slot is not synced and there =
is autofailover? Will there be a data loss?</font></span></div><div><span s=
tyle=3D"color:rgb(0,0,0)"><font face=3D"arial, sans-serif"><br></font></spa=
n></div><div><span style=3D"color:rgb(0,0,0)"><font face=3D"arial, sans-ser=
if">Thanks,</font></span></div><div><span style=3D"color:rgb(0,0,0)"><font =
face=3D"arial, sans-serif">Nikhil</font></span></div></div>
</blockquote></div>

--0000000000001562d30625459753--