MIME-Version: 1.0
From: Mukesh Tanuku <mukesh.postgres@gmail.com>
Date: Fri, 12 Jul 2024 20:41:03 +0530
Message-ID: <CAJzgB-FgxbU15L3iyu84B8ZJdOvqfY9HM4s2Qc27f74=a43MKA@mail.gmail.com>
Subject: Replication lag in Postgres
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000057f7fa061d0e4a06"
Archived-At: <https://www.postgresql.org/message-id/CAJzgB-FgxbU15L3iyu84B8ZJdOvqfY9HM4s2Qc27f74%3Da43MKA%40mail.gmail.com>
Precedence: bulk

--00000000000057f7fa061d0e4a06
Content-Type: text/plain; charset="UTF-8"

Hello everyone.
Firstly thanks to the community members who are addressing all the queries
that are posted. Those give us more insights about the issues/doubts in the
postgres.

I have a question with postgres HA setup.
We are setting up a 2 node postgres cluster with async streaming
replication, we want to define a RPO (Recovery point objective) in case of
primary failure.

How can we best define the RPO in this setup? since it's an async streaming
replication setup there might be a chance of data loss which is
proportional to the replication delay.

Is there any way we can configure the delay duration, like for example to
make sure every 10 mins the standby sync has to happen with primary?

Thank you
Regards
Mukesh T

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

<div dir=3D"ltr">Hello everyone.=C2=A0<div>Firstly thanks to the community =
members=C2=A0who are addressing all the queries that are posted. Those give=
 us more insights=C2=A0about the issues/doubts in the postgres.=C2=A0</div>=
<div><br><div>I have a question with postgres HA setup.<br><div>We are sett=
ing up a 2 node postgres cluster with async streaming replication, we want =
to define a RPO (Recovery point objective) in case of primary failure.=C2=
=A0</div><div><br></div><div>How can we best define=C2=A0the RPO in this se=
tup? since it&#39;s an async streaming replication setup there might be a c=
hance of data loss which is proportional to the replication delay.=C2=A0</d=
iv><div><br></div><div>Is there any way we can configure=C2=A0the delay dur=
ation, like for example to make sure every 10 mins the standby sync has to =
happen with primary?=C2=A0</div><div><br></div><div>Thank you</div><div>Reg=
ards=C2=A0</div><div>Mukesh T</div><div class=3D"gmail-yj6qo"></div><div cl=
ass=3D"gmail-adL"><br></div></div></div></div>

--00000000000057f7fa061d0e4a06--