RE: [EXTERNAL] Re: Queries are failing on standby server

This is an issue at most place. Don't give out the r/o login to the Replica. The Replica is not a data research /prod sandbox box, it's a streaming replica for HA failover. If you want a research r/o query box, create one.

-----Original Message-----
From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Sent: Thursday, July 25, 2024 11:36 AM
To: Wasim Devale <wasimd60(at)gmail(dot)com>
Cc: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>; pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: [EXTERNAL] Re: Queries are failing on standby server

> On Jul 25, 2024, at 11:17 AM, Wasim Devale <wasimd60(at)gmail(dot)com> wrote:
>
> So how to tackle the above error.

???

The two options to mitigate this, and their side effects, were explained to you. What more do you want?

----------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2024 Evernorth