Thread: DR setup in RHOS

DR setup in RHOS

From

Rajesh Kumar

Date:

26 July, 07:53:04

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

Re: DR setup in RHOS

From

akshay polji

Date:

27 July, 05:37:17

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@gmail.com> 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

Re: DR setup in RHOS

From

Rajesh Kumar

Date:

27 July, 11:33:55

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@gmail.com> 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@gmail.com> 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

Re: DR setup in RHOS

From

Rajesh Kumar

Date:

27 July, 11:34:48

We are using openshift

On Sat, 27 Jul 2024, 14:03 Rajesh Kumar, <rajeshkumar.dba09@gmail.com> 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@gmail.com> 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@gmail.com> 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

Re: DR setup in RHOS

From

Joe Conway

Date:

27 July, 16:33:51

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

Re: DR setup in RHOS

From

Muhammad Waqas

Date:

30 July, 15:32:59

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

Re: DR setup in RHOS

From

Rajesh Kumar

Date:

31 July, 04:18:16

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

Re: DR setup in RHOS

From

SOzcn

Date:

31 July, 08:05:15

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

Re: DR setup in RHOS

From

khan Affan

Date:

31 July, 09:35:53

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 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@gmail.com> 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@gmail.com> 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@gmail.com> 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

Re: DR setup in RHOS

From

Rajesh Kumar

Date:

31 July, 10:30:18

So we should have two pgbouncer, two pgbackrest ?

On Wed, 31 Jul 2024, 12:06 khan Affan, <bawag773@gmail.com> wrote:

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 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@gmail.com> 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@gmail.com> 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@gmail.com> 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

Re: DR setup in RHOS

From

khan Affan

Date:

31 July, 10:33:47

Yes for each node to function separately, you have to setup both on them.

On Wed, Jul 31, 2024 at 12:30 PM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:

So we should have two pgbouncer, two pgbackrest ?
On Wed, 31 Jul 2024, 12:06 khan Affan, <bawag773@gmail.com> wrote:
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 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@gmail.com> 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@gmail.com> 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@gmail.com> 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