Обсуждение: Streams replication and Failover failback
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
Datta
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 AdminsI 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
On Sat, Jun 8, 2024 at 10:15 AM Datta D <dattadeshpande.it@gmail.com> wrote:
Dear AdminsI 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)?