From: | khan Affan <bawag773(at)gmail(dot)com> |
---|---|
To: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
Cc: | akshay polji <akshay(dot)polji(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: DR setup in RHOS |
Date: | 2024-07-31 07:33:47 |
Message-ID: | CAF4emOnquutE2_X-0s6ZUJ6-Lear4pXY=tiSK8enHManK56b_g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)dba09(at)gmail(dot)com>
wrote:
> 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
>>>>>
>>>>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2024-08-02 19:16:06 | measuring WAL creation |
Previous Message | Rajesh Kumar | 2024-07-31 07:30:18 | Re: DR setup in RHOS |