Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtTTZ-00CWZb-NB for pgsql-admin@arkaria.postgresql.org; Thu, 19 Oct 2023 13:54:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qtTTW-0020sh-P4 for pgsql-admin@arkaria.postgresql.org; Thu, 19 Oct 2023 13:54:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtTTV-0020sZ-Oj for pgsql-admin@lists.postgresql.org; Thu, 19 Oct 2023 13:54:11 +0000 Received: from resqmta-h1p-028591.sys.comcast.net ([2001:558:fd02:2446::9]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtTTP-001YIX-T0 for pgsql-admin@postgresql.org; Thu, 19 Oct 2023 13:54:09 +0000 Received: from resomta-h1p-027919.sys.comcast.net ([96.102.179.208]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 256/256 bits) (Client did not present a certificate) by resqmta-h1p-028591.sys.comcast.net with ESMTP id tTHYqTWPRyoCltTTIqjdbN; Thu, 19 Oct 2023 13:53:56 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1697723636; bh=yqTY0wK/CxYD7RC9H7tblgrWhK8fRp7bMr4JSU3Mn74=; h=Received:Received:Content-Type:From:Mime-Version:Subject:Date: Message-Id:To:Xfinity-Spam-Result; b=bJBmWyGjMNnX6y4uoTpMMyYqx0iKMfsAtowtYtVb+GyLFy6jcuS6c51fTTLPRSVxm TXL6C/JJYCf60tB5lPgIRXUy67JTJAUlBrZjAyh+NxYz9muqokKTUix5ixMCqQoWsa /t/xwJ4Xkc609UTLR12pzpV6PqN2GBP7D7RcHcYDybdLaCqz1ZeBu3IBoXPWAGhZd0 HETXScxhmD1mcJu2TMfmqTKHC+fe2OqRfFAecsONkUi31ct8T/thvybfPweSflA6kc nj6m/mACZDAL651o+12cX9wsc9OA2EyKt5yla8AtB7wZEVEgav0ZHRLg0ZLl2RFJq0 JIOQQa0RKj47A== Received: from smtpclient.apple ([IPv6:2601:240:d000:c160:4c7d:983:1eda:b7f5]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 256/256 bits) (Client did not present a certificate) by resomta-h1p-027919.sys.comcast.net with ESMTPA id tTTAqsFB3uJe4tTTCqWuRc; Thu, 19 Oct 2023 13:53:51 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgedvkedrjeeigdeilecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucevohhmtggrshhtqdftvghsihdpqfgfvfdppffquffrtefokffrnecuuegrihhlohhuthemuceftddunecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenqfhnlhihuchonhgvuchprghrthculdehuddmnecujfgurheptgfghfggufffkfhfvegjvffosegrjehmrehhtdejnecuhfhrohhmpeflfihivghntggvkhefuceojhifihgvnhgtvghkfeestghomhgtrghsthdrnhgvtheqnecuggftrfgrthhtvghrnhepteeiveehhfettefgudekkeefueefuedvieekgfeuuddtjedtleekgffhtefhgfelnecuffhomhgrihhnpegrkhgrrdhmshenucfkphepvdeitddumedvgedtmegutddttdemtgduiedtmeegtgejugemleekfeemudgvuggrmegsjehfheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhephhgvlhhopehsmhhtphgtlhhivghnthdrrghpphhlvgdpihhnvghtpedviedtudemvdegtdemugdttddtmegtudeitdemgegtjegumeelkeefmeduvggurgemsgejfhehpdhmrghilhhfrhhomhepjhifihgvnhgtvghkfeestghomhgtrghsthdrnhgvthdpnhgspghrtghpthhtohepfedprhgtphhtthhopehpghhsqhhlqdgrughmihhnsehpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopehvvggvrhgvnhgurhgrrdhpuhhlrghprgesrghshhhnihhkrdgtohhmpdhrtghpthhtoheplhhitghiohdrmhgrthhoshesghhmrghilhdrtghomh X-Xfinity-VMeta: sc=-49.00;st=legit Content-Type: multipart/alternative; boundary=Apple-Mail-C0AF5AFC-E6E4-4D53-AF38-D805816B1B77 Content-Transfer-Encoding: 7bit From: Jwiencek3 Mime-Version: 1.0 (1.0) Subject: Re: Need assistance for replication sync issue Date: Thu, 19 Oct 2023 08:53:38 -0500 Message-Id: References: Cc: Veerendra Pulapa , pgsql-admin In-Reply-To: To: Licio Matos X-Mailer: iPad Mail (20G81) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-C0AF5AFC-E6E4-4D53-AF38-D805816B1B77 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Look at using synchronous replication.
<= br>
Sent from my iPad

On Oct 19, 2023, at 5:38 AM, Licio Matos <licio.matos@gmail.= com> wrote:

=EF=BB=BF
Hi Veerendra,

Is your servers, primary and secondary, the same size?= CPU, Memory etc.


Licio Matos

<= div>
Em q= ui., 19 de out. de 2023 =C3=A0s 07:12, Veerendra Pulapa <veerendra.pulapa@ashnik.com> escreveu:=
Hello,

I need some help with a database issue we=E2=80=99re facing. We have a s= ituation where our primary data center and our disaster recovery site are fa= r apart, and this long distance is causing delays in keeping our data synchr= onized. It=E2=80=99s 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= =E2=80=99ve tried a few things, but we=E2=80=99re still struggling with the r= eplication delays caused by the high latency between the sites.

Note: Bandwidth is very low and latency is very high.
=

I=E2=80=99d appreciate any advice you can provide.

Thanks in advance.

Get Outlook for iOS<= /div>
= --Apple-Mail-C0AF5AFC-E6E4-4D53-AF38-D805816B1B77--