Postgres Pro
Downloads
Home   >   mailing lists

Permisson Required - Mailing list pgsql-admin

From ROHIT SACHDEVA
Subject Permisson Required
Date
Msg-id CAKDb7aHwa_c=mz3OXra=B9ez3x-5FcEnPxQWxEj1jdvM-Y=GXA@mail.gmail.com
Whole thread Raw
In response to Queries in replica are failing  (Siraj G <tosiraj.g@gmail.com>)
Responses Re: Permisson Required
List pgsql-admin
Tree view
Hi Team,

There is a requirement of giving select access on few tables and hide other tables in a database of postgres 14 in RDS.

Is it possible or not.

What is the way around for the same.

On Thu, 16 May, 2024, 5:31 pm Siraj G, <tosiraj.g@gmail.com> wrote:
Hello -

Queries in replica instance are failing with the error "cancelling statement due to conflict with recovery". I was checking two parameters (max_standby_archive_delay and max_standby_streaming_delay)  which may allow the queries to run within the time defined in those.

Is it recommended to set those? Is there any other suggestion to tackle this?

Regards
Siraj

pgsql-admin by date:

Previous
From: Mauricio Fernandez
Date:
Subject: Re: Few extensions, pg_stat_statements not available
Next
From: "David G. Johnston"
Date:
Subject: Re: Permisson Required