Re: Streams replication and Failover failback

Hi,

Lot of material is available on setting up streaming replication and
failover.

Here is a good article by pgEdge about setting up streaming replication.

https://www.percona.com/blog/setting-up-streaming-replication-postgresql/

You may set up the Patroni cluster for failover and in conjunction with
pg_rewind to sync back the failed node when it comes back online. Hope
below article will be helpful.

https://jfrog.com/community/devops/highly-available-postgresql-cluster-using-patroni-and-haproxy/

Regards,
Muhammad Ikram
Bitnine Global.

On Sat, Jun 8, 2024 at 7:15 PM Datta D <dattadeshpande(dot)it(at)gmail(dot)com> wrote:

> Dear Admins
> I have a requirement for setting up stream replication in postgres with
> failover / failback capacity between Prod and DR.
> What is process to set up Streams replication (if steps)?
> What is process of failover and failback from Primary to DR and vice
> versa.
> Please advise.
>
> Thanks
> Datta
>

--
Muhammad Ikram