Re: DR setup in RHOS - Mailing list pgsql-admin

From SOzcn
Subject Re: DR setup in RHOS
Date
Msg-id CAJyV5AZCZ4Dg4XyMOq0Tzj4tDyV7KZZsF6OjQFwCFrxermLngg@mail.gmail.com
Whole thread Raw
In response to Re: DR setup in RHOS  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
List pgsql-admin
Hello,

What's the real issue? On this page, I don't see anything to block your DR system. You can make it with Patroni again when you create the PostgreSQL just up your cluster with Patroni. There is no block, you should revise your configs for the third node. 

My advice is to test environment on your local and try. It's the best way to see what you need to do.

Rajesh Kumar <rajeshkumar.dba09@gmail.com>, 31 Tem 2024 Çar, 04:18 tarihinde şunu yazdı:

We are already using  patroni.

On Tue, 30 Jul 2024, 18:03 Muhammad Waqas, <waqas.m@bitnine.net> wrote:
Please read Stream replication and repmgr tool

Regards,
Muhammad Waqas
Bitnine


2024년 7월 27일 (토) 오후 6:33, Joe Conway <mail@joeconway.com>님이 작성:
On 7/27/24 04:34, Rajesh Kumar wrote:
>     We are already using patroni.  With the postgres operator, we have
>     pgbouncer, pgbackrest and 2 nodes for postgres.
>
>     If we want to perform the same as DR setup , how do I replicate
>     pgbouncer, pgbackrest and  postgres ?


>     What configuration changes I have to make in pgbouncer, pgbackrest,
>     patroni and postgres? Some hint or idea on this if not in detail?

>             We have one master and one replica(15.6) postgres in primary
>             datacenter on platform openshift version 4.14.
>
>             We are looking for DR set up , for postgres in another
>             datacenter in RHOS running on Hyper converged infrastructure
>             fusion.
>
>             Kindly help me with som points

This is likely too complex an ask for a mailing list. My recommendation
is that you get help from a company that knows well how to run
PostgreSQL on Openshift. For example:

https://www.crunchydata.com/products/crunchy-postgresql-for-kubernetes

--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com



pgsql-admin by date:

Previous
From: Siraj G
Date:
Subject: Re: Logical replication data lag
Next
From: Muhammad Imtiaz
Date:
Subject: Re: Logical replication data lag