Postgres Pro
Downloads
Home   >   mailing lists

Re: Streams replication and Failover failback - Mailing list pgsql-admin

From Muhammad Ikram
Subject Re: Streams replication and Failover failback
Date
Msg-id CAGeimVrhTv06xvVDuWc2mrpYL4KXP-ZSnVkjbTd6c7irzP0GgQ@mail.gmail.com
Whole thread Raw
In response to Streams replication and Failover failback  (Datta D <dattadeshpande.it@gmail.com>)
List pgsql-admin
Tree view
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.


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.



Regards,
Muhammad Ikram
Bitnine Global.


On Sat, Jun 8, 2024 at 7:15 PM Datta D <dattadeshpande.it@gmail.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

pgsql-admin by date:

Previous
From: Datta D
Date:
Subject: Streams replication and Failover failback
Next
From: Ron Johnson
Date:
Subject: Re: Streams replication and Failover failback