Re: PostgreSQL Community Enquire !

Hi On Tue, Jun 25, 2024 at 4:29 AM madhav sira wrote: > Dear PostgreSQL Community, > > > I am new to the PostgreSQL community. I am writing to seek guidance on the > best practices for engaging with the community, particularly regarding > where to post questions related to SQL queries and genera

Re: schema privileges and drop role

Matt Zagrabelny writes: > On Mon, Jun 24, 2024 at 7:03 PM Adrian Klaver > wrote: >> "A role cannot be removed if it is still referenced in any database of >> the cluster; an error will be raised if so. Before dropping the role, >> you must drop all the objects it owns (or reassign their ownership

Re: schema privileges and drop role

Hi Adrian, Thanks for the reply! On Mon, Jun 24, 2024 at 7:03 PM Adrian Klaver wrote: > On 6/24/24 17:00, Matt Zagrabelny wrote: > > Greetings, > > > > I have a database that I recently changed the ownership for and now I am > > attempting to drop the previous owner of the database: > > > > tes

Re: Issue with pgstattuple on Sequences in PostgreSQL

> On Monday, June 24, 2024, Ayush Vatsa wrote: >> >> I was recently exploring the pgstattuple code directory and found this >> piece of code: https://github.com/postgres/postgres/blob/master/contrib/ >> pgstattuple/pgstattuple.c#L255-L259. >> >> It indicates that pgstattuple supports relations, to

Re: schema privileges and drop role

On 6/24/24 17:00, Matt Zagrabelny wrote: Greetings, I have a database that I recently changed the ownership for and now I am attempting to drop the previous owner of the database: test_db=# drop ROLE legacy_owner; ERROR:  role "legacy_owner" cannot be dropped because some objects depend on i

schema privileges and drop role

Greetings, I have a database that I recently changed the ownership for and now I am attempting to drop the previous owner of the database: test_db=# drop ROLE legacy_owner; ERROR: role "legacy_owner" cannot be dropped because some objects depend on it DETAIL: privileges for schema public I don

Re: PostgreSQL Community Enquire !

On 6/24/24 16:28, madhav sira wrote: Dear PostgreSQL Community, I am new to the PostgreSQL community. I am writing to seek guidance on the best practices for engaging with the community, particularly regarding where to post questions related to SQL queries and general database issues. In o

PostgreSQL Community Enquire !

Dear PostgreSQL Community, I am new to the PostgreSQL community. I am writing to seek guidance on the best practices for engaging with the community, particularly regarding where to post questions related to SQL queries and general database issues. In other database communities, such as the Orac

Re: Execute permission to function

On 6/24/24 11:10 AM, arun chirappurath wrote: Hi, Only see select script here in pg_admin.. I don't see any active servers in the Browser pane. Have you done?: https://www.pgadmin.org/docs/pgadmin4/8.8/connecting.html If you have set up a server what connection parameters did you use?

Re: Password complexity/history - credcheck?

## Martin Goodson (kaema...@googlemail.com): > Crikey, that would be  quite a lot of  lot of SSL/TLS to set up. We > have quite a few (massive understatement :( ... ) PostgreSQL database > clusters spread over quite a lot (another understatement) of VMs. No matter what: you'll have to touch all y

Re: Execute permission to function

On 6/24/24 03:29, arun chirappurath wrote: Hi all I am using rds postgres 14. I have created few users and added them to pg_readall_data and pg_write_alldata groups They are able to read all data and do update in tables However they can't execute functions and not able to script out objects

Re: Issue with pgstattuple on Sequences in PostgreSQL

On 6/24/24 04:09, Ayush Vatsa wrote: Hi PostgreSQL Community, I was recently exploring the pgstattuple code directory and found this piece of code: https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgstattuple.c#L255-L259

Re: Issue with pgstattuple on Sequences in PostgreSQL

On Monday, June 24, 2024, Ayush Vatsa wrote: > > I was recently exploring the pgstattuple code directory and found this > piece of code: https://github.com/postgres/postgres/blob/master/contrib/ > pgstattuple/pgstattuple.c#L255-L259. > > It indicates that pgstattuple supports relations, toast tabl

Re: 2FA - - - was Re: Password complexity/history - credcheck?

On Mon, Jun 24, 2024 at 8:00 PM o1bigtenor wrote: > > > On Sun, Jun 23, 2024 at 10:10 AM Greg Sabino Mullane > wrote: > >> On Sun, Jun 23, 2024 at 5:30 AM Martin Goodson >> wrote: >> >>> I believe that our security team is getting most of this from our >>> auditors, who seem convinced that mini

Re: Execute permission to function

On Monday, June 24, 2024, arun chirappurath wrote: > > However they can't execute functions > Community PG at least gives the public pseudo-role permission to execute all functions it can see (i.e., schema access permitted). But no, there is no predefined role that enables that function executi

2FA - - - was Re: Password complexity/history - credcheck?

On Sun, Jun 23, 2024 at 10:10 AM Greg Sabino Mullane wrote: > On Sun, Jun 23, 2024 at 5:30 AM Martin Goodson > wrote: > >> I believe that our security team is getting most of this from our >> auditors, who seem convinced that minimal complexity, password history >> etc are the way to go despite

Re: Issue with pgstattuple on Sequences in PostgreSQL

On Mon, Jun 24, 2024 at 7:09 AM Ayush Vatsa wrote: [snip] > How can one use pgstattuple on sequences? > Out of curiosity... *why*?

Re: Execute permission to function

On Mon, Jun 24, 2024 at 6:29 AM arun chirappurath wrote: > Hi all > > I am using rds postgres 14. I have created few users and added them to > pg_readall_data and pg_write_alldata groups > > > They are able to read all data and do update in tables > > However they can't execute functions > https

Re: Issue with pgstattuple on Sequences in PostgreSQL

Hi I dont think Sequences are support, please refer to the following documentation. https://www.postgresql.org/docs/current/pgstattuple.html Regards Kashif Zeeshan On Mon, Jun 24, 2024 at 4:09 PM Ayush Vatsa wrote: > Hi PostgreSQL Community, > > I was recently exploring the pgstattuple code d

Issue with pgstattuple on Sequences in PostgreSQL

Hi PostgreSQL Community, I was recently exploring the pgstattuple code directory and found this piece of code: https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgstattuple.c#L255-L259 . It indicates that pgstattuple supports relations, toast tables, materialized views, and seq

Execute permission to function

Hi all I am using rds postgres 14. I have created few users and added them to pg_readall_data and pg_write_alldata groups They are able to read all data and do update in tables However they can't execute functions and not able to script out objects from pg_admin Any other role to be added? Th

Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34.

Dmitry O Litvintsev wrote: > Just want to make clear (sorry I am slow on uptake). I should first > REINDEX and then ALTER DATABASE xxx REFRESH COLLATION VERSION, or > first ALTER and then REINDEX or does the order of these action > matter at all? The order does not matter. The ALTER DATAB

Re: Upgrade PG from 12 to latest

On Sun, 2024-06-23 at 10:08 +0300, Doron Tsur wrote: > We are running PG 12 on AWS RDS. I want to run an upgrade process for the DB. > The org I work for attempted to upgrade before but failed (12->15). The > upgrade > resulted in unexplained slowness, and performance issues were only resolved >

Re: Password complexity/history - credcheck?

On Sun, 2024-06-23 at 14:14 +0100, Martin Goodson wrote: > On 23/06/2024 11:49, Christoph Moench-Tegeder wrote: > > My advice would be to not use secrets stored in the database - > > that is, do not use scram-sha-256 - but use an external authentication > > system, like Kerberos (might be AD) or LD