[HACKERS] Allow pg_dumpall to work without pg_authid - Mailing list pgsql-hackers

From Robins Tharakan
Subject [HACKERS] Allow pg_dumpall to work without pg_authid
Date
Msg-id CAEP4nAz9V4H41_4ESJd1Gf0v=devkqO1=po91jUw-GJSx8Hxqg@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] Allow pg_dumpall to work without pg_authid
Re: [HACKERS] Allow pg_dumpall to work without pg_authid
List pgsql-hackers
Hi,

I would like to work on a patch to accommodate restricted environments (such as AWS RDS Postgres) which don't allow pg_authid access since their definition of Superuser is just a regular user with extra permissions.

Would you consider a patch to add a flag to work around this restriction, Or, do you prefer that this be maintained outside core?

I could add a flag such as --avoid-pgauthid (am open to options) that skips pg_authid and uses pg_user (but essentially resets all User passwords). Mostly this is better than not being able to get the dump at all.

I have a fork here (a few weeks old):

Thanks
Robins Tharakan
--

-
robins

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Instability in select_parallel regression test
Next
From: Thomas Munro
Date:
Subject: Re: [HACKERS] [COMMITTERS] pgsql: Add new function dsa_allocate0.