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?
