RE: [EXTERNAL] Re: Queries are failing on standby server - Mailing list pgsql-admin

From Wetmore, Matthew (CTR)
Subject RE: [EXTERNAL] Re: Queries are failing on standby server
Date
Msg-id PH0PR12MB5499F086182F8D18F5BBD8E7F5B42@PH0PR12MB5499.namprd12.prod.outlook.com
Whole thread Raw
In response to Re: Queries are failing on standby server  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
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
sandboxbox, 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@elevated-dev.com> 
Sent: Thursday, July 25, 2024 11:36 AM
To: Wasim Devale <wasimd60@gmail.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>; pgsql-admin <pgsql-admin@postgresql.org>
Subject: [EXTERNAL] Re: Queries are failing on standby server

> On Jul 25, 2024, at 11:17 AM, Wasim Devale <wasimd60@gmail.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
addressshown. This email transmission may contain confidential information.  This information is intended only for the
useof the individual(s) or entity to whom it is intended even if addressed incorrectly.  Please delete it from your
filesif you are not the intended recipient.  Thank you for your compliance.  Copyright (c) 2024 Evernorth 

pgsql-admin by date:

Previous
From: Keith Fiske
Date:
Subject: Re: How to detect if a postgresql gin index is bloated
Next
From: Ron Johnson
Date:
Subject: Re: Migration from CentOS7 to RHEL red hat Linux