Re: Streams replication and Failover failback

[Muhammad Ikram <mmikram@xxxxxxxxx>]

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.it@xxxxxxxxx> 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