On 19 February 2017 at 17:02, Robins Tharakan <thara...@gmail.com> wrote:
> On Sun, 19 Feb 2017 at 10:08 Stephen Frost <sfr...@snowman.net> wrote:
>> If anything, it should use pg_roles, not pg_user.
>> I don't really like the "--avoid-pgauthid" option, but "--no-passwords"
>> would probably work.
> '--no-passwords' is a good alternative.
> Would submit a patch soon.
After reviewing further, it seems that merely adding a password related
workaround wouldn't suffice. Further --no-password is already an alias for
-w, so that flag is effectively taken.

Since the main restriction with AWS RDS is the unavailability of pg_authid,
probably that is a better basis to name the flag on.

Attaching a patch to add a new flag (--no-pgauthid) to pg_dumpall that can
dump Globals without needing pg_authid. So the following works with AWS RDS
Postgres databases.

pg_dumpall --no-pgauthid --globals-only > a.sql

I'll create a Commitfest entry, if there aren't many objections.


Attachment: pgdumpall_nopgauthid_flag.diff.gz
Description: GNU Zip compressed data

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to