Re: insufficient privilege with pg_read_all_stats granted

On 20.08.2024 23:50, Costa Alexoglou wrote: I run PostgreSQL v15.8 (docker official image), and there is an issue when reading pg_stat_staments table with a result of query most of the times having `` value. I have created the user that I use to fetch the data with the following way: ``` CRE

Re: insufficient privilege with pg_read_all_stats granted

On 21.08.2024 10:50, Pavel Luzanov wrote: But I don't understand why it worked in v14. Probablysomethinghas changed, butIcouldn't quicklyfindwhatexactly. Ifoundit. https://github.com/postgres/postgres/commit/6198420a -- Pavel Luzanov Postgres Professional:https://postgrespro.com

security invoker review need full select (all columns) to do DML?

hi. the following setup is extract from src/test/regress/sql/updatable_views.sql you can search keywords: "-- ordinary view on top of security invoker view permissions" CREATE USER regress_view_user1; CREATE USER

pgbackrest restore with a checkpoint and timestamp after the checkpoint

List, Query: Can I perform a pgbackrest restore with the last backup diff or incr + further transactions in the WAL replayed to restore the transactions that happened after the last pgbackrest backup checkpoint ? Scenario: I am trying to perform this and unable to get a solution. I h

Re: security invoker review need full select (all columns) to do DML?

On Wed, 21 Aug 2024 at 10:08, jian he wrote: > > the following setup is extract from src/test/regress/sql/updatable_views.sql > you can search keywords: "-- ordinary view on top of security invoker > view permissions" > > CREATE TABLE base_tbl(a int, b text, c float); > INSERT INTO base_tbl VALUES

Re: security invoker review need full select (all columns) to do DML?

Dean Rasheed writes: > The user must have select permissions on all columns selected by the > subquery/view, because we don't go through the outer query to check > which columns are actually referred to. Now maybe we could, but I > suspect that would be quite a lot of effort because you'd need to

Query tuning question

Aurora Postgres version 13.7. Table definition: acquisition_channel_db=> \d acquisition_channel.acquired_object Table "acquisition_channel.acquired_object" Column | Type | Collation | Nu

Npgsql.dll

I'm trying to get the latest version so I can use it in my Powershell script. I think I have 4.51 but having issues connection to server from script. I get this error: Exception calling "Open" with "0" argument(s): "Authentication method not supported (Received: 10)"

Re: Npgsql.dll

> On 21 Aug 2024, at 18:58, Andy Hartman wrote: > > I'm trying to get the latest version so I can use it in my Powershell script. > I think I have 4.51 but having issues connection to server from script. > > I get this error: > > Exception calling "Open" with "0" argument(s): "Authentication m

unable to upgrade postgres extensions

AWS RDS Postgres database on v12.17 is upgraded to v16.1, as per https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-16x am trying to upgrade pg_cron and pgaudit extensions but it keeps throwing the same error, how to upgrade them? p

Re: insufficient privilege with pg_read_all_stats granted

> I think the problem is in the NOINHERIT attribute for the abcd role. Indeed that is the issue, thanks for helping find this out >

Re: unable to upgrade postgres extensions

On 8/21/24 12:14, plsqlvids01 plsqlvids01 wrote: AWS RDS Postgres database on v12.17 is upgraded to v16.1, as per https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-16x

Re: unable to upgrade postgres extensions

On 2024-Aug-21, plsqlvids01 plsqlvids01 wrote: > AWS RDS Postgres database on v12.17 is upgraded to v16.1, as per > https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-16x > am > trying to upgrade pg_cron and pgaudit extensions but i

Re: unable to upgrade postgres extensions

plsqlvids01 plsqlvids01 writes: > AWS RDS Postgres database on v12.17 is upgraded to v16.1, as per > https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-16x > am > trying to upgrade pg_cron and pgaudit extensions but it keeps throwin