Hi Rajesh
Question: Do you need streaming replication to this new DR primary Node from the previous DR Cluster?
Take a base backup from your existing primary DR PG instance using
Transfer this backup to your new DR site.
Restore the backup to your new DR PostgreSQL instance. Ensure that the recovery settings (like
Configure your primary PostgreSQL instance to archive WAL files.
Enable streaming replication for the standby node as you have made changes in conf in previous DR.
Then
You have to do it manually by installing PGbouncer and Patroni.
You can use the `patroni.yaml` file from the previous DR setup, adjust it for the new DR environment with the Postgres cluster, and do the same for the PGbouncer configurations.
But all of this needs to be done on a local machine first.
Thanks
Question: Do you need streaming replication to this new DR primary Node from the previous DR Cluster?
Take a base backup from your existing primary DR PG instance using
pg_basebackup
or pgBackRest
. Transfer this backup to your new DR site.
Restore the backup to your new DR PostgreSQL instance. Ensure that the recovery settings (like
restore_command)
are properly configured to fetch WAL files. Configure your primary PostgreSQL instance to archive WAL files.
Enable streaming replication for the standby node as you have made changes in conf in previous DR.
Then
You have to do it manually by installing PGbouncer and Patroni.
You can use the `patroni.yaml` file from the previous DR setup, adjust it for the new DR environment with the Postgres cluster, and do the same for the PGbouncer configurations.
But all of this needs to be done on a local machine first.
Thanks
Muhammad Affan (아판)
PostgreSQL Technical Support Engineer / Pakistan R&D
On Sat, Jul 27, 2024 at 1:34 PM Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx> 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?
On Sat, 27 Jul 2024, 08:07 akshay polji, <akshay.polji@xxxxxxxxx> wrote:Hello Rajesh,
I believe this is an incomplete question. What help are you looking for ?
Thanks & Regards,
Akshay Polji.On Fri, 26 Jul, 2024, 10:23 am Rajesh Kumar, <rajeshkumar.dba09@xxxxxxxxx> wrote:Hi All,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