Re: Need assistance for replication sync issue

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Veerendra Pulapa <veerendra(dot)pulapa(at)ashnik(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Need assistance for replication sync issue
Date: 2023-10-19 10:55:08
Message-ID: 4f6bd1b4459a1480e5938f40d4a752ca7edf4b2d.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 2023-10-19 at 10:08 +0000, Veerendra Pulapa wrote:
> 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?

Yes: don't use synchronous replication.

You are fighting with physics (speed of light), not with an implementation
deficiency. You cannot win that fight.

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2023-10-19 12:36:50 Re: Need assistance for replication sync issue
Previous Message Licio Matos 2023-10-19 10:38:19 Re: Need assistance for replication sync issue