Re: DR setup in RHOS

So we should have two pgbouncer, two pgbackrest ?

On Wed, 31 Jul 2024, 12:06 khan Affan, <bawag773(at)gmail(dot)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(dot)dba09(at)gmail(dot)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(dot)polji(at)gmail(dot)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(dot)dba09(at)gmail(dot)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
>>>>
>>>