Replication lag in Postgres

From: Mukesh Tanuku <mukesh(dot)postgres(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Replication lag in Postgres
Date: 2024-07-12 15:11:03
Message-ID: CAJzgB-FgxbU15L3iyu84B8ZJdOvqfY9HM4s2Qc27f74=a43MKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2024-07-12 15:43:24 Re: Replication lag in Postgres
Previous Message felix.quintgz 2024-07-12 13:52:29 Re: Running psql in a docker container