Re: Need assistance for replication sync issue

Dears,

Thank you all for your response. Below are the general details about our
setup.

Our setup is DC & DR.
On DC: Three nodes(one master, Two replicas) and replication mode is
asynchronous between DC.
On DR: One replica and replication mode is asynchronous between DC & DR.
All four nodes have the same configuration such as CPU,RAM and Disks.
In DC no replication & in DR yes it's always replication lag due to this
our replication got broken.
The setup runs on on-prem RHEL 7.9 and PG 12.x.

Is there a way to perform an incremental data restore if replication breaks
at a certain point? The data size is substantial, and when replication
breaks between the DC and DR, it takes 3 to 4 days to rebuild the replica.

Br,
Veerendra Pulapa | Technical Consultant
M: +91-9949349894 | www.ashnik.com

<https://www.ashnik.com/>

<https://www.linkedin.com/company/ashnik-pte-ltd/>
<https://www.facebook.com/AshnikBiz>
<https://www.youtube.com/user/ashnikbiz>
<https://www.instagram.com/ashnikbiz/> <https://twitter.com/Ashnikbiz>

On Thu, Oct 19, 2023 at 7:23 PM Jwiencek3 <jwiencek3(at)comcast(dot)net> wrote:

> Look at using synchronous replication.
>
> Sent from my iPad
>
> On Oct 19, 2023, at 5:38 AM, Licio Matos <licio(dot)matos(at)gmail(dot)com> wrote:
>
> 
> Hi Veerendra,
>
> Is your servers, primary and secondary, the same size? CPU, Memory etc.
>
>
> Licio Matos
>
>
> Em qui., 19 de out. de 2023 às 07:12, Veerendra Pulapa <
> veerendra(dot)pulapa(at)ashnik(dot)com> escreveu:
>
>> Hello,
>>
>> I need some help with a database issue we’re facing. We have a situation
>> where our primary data center and our disaster recovery site are far apart,
>> and this long distance is causing delays in keeping our data synchronized.
>> It’s become a problem as we want our data to be as up-to-date as possible.
>>
>> Do you have any suggestions for dealing with this kind of situation?
>> We’ve tried a few things, but we’re still struggling with the replication
>> delays caused by the high latency between the sites.
>>
>> Note: Bandwidth is very low and latency is very high.
>>
>> I’d appreciate any advice you can provide.
>>
>> Thanks in advance.
>>
>> Get Outlook for iOS <https://aka.ms/o0ukef>
>>
>