From: Joe Conway <mail@joeconway.com>
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
To: akshay polji <akshay.polji@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: DR setup in RHOS
Date: Sat, 27 Jul 2024 09:33:51 -0400
Message-ID: <07bae32b-f757-47c9-8f3c-b4e0e261dc44@joeconway.com> (raw)
In-Reply-To: <CAJk5AtZhhyw1M4KXhVow3CcjSm9rAhLjRmxGjHe5BNbyN7LVRQ@mail.gmail.com>
References: <CAJk5AtYPgwz_tV3htx_MwhJb5eC7d0u+qxEXsS8T=PsUiLV55A@mail.gmail.com>
<CAHecRemCBN5Xnowa+o51tHNM_9Pw7dAco6wBh_W3kZM-WUuEgw@mail.gmail.com>
<CAJk5Atao9K1z1Pf0_5Tvz3h5STy7E=D4mySSwUU7+oi4Ftrr2Q@mail.gmail.com>
<CAJk5AtZhhyw1M4KXhVow3CcjSm9rAhLjRmxGjHe5BNbyN7LVRQ@mail.gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mail@joeconway.com, rajeshkumar.dba09@gmail.com, akshay.polji@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: DR setup in RHOS
In-Reply-To: <07bae32b-f757-47c9-8f3c-b4e0e261dc44@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox