Re: Allow pg_dumpall to work without pg_authid

Stephen Frost <sfrost@snowman.net>

From: Stephen Frost <sfrost@snowman.net>
To: Sachin Kotwal <kotsachin@gmail.com>
Cc: Simon Riggs <simon@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>, Robins Tharakan <tharakan@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2017-03-15T13:56:19Z
Lists: pgsql-hackers
Greetings,

* Sachin Kotwal (kotsachin@gmail.com) wrote:
> Thanks. I understand this is small but new feature and not bug fix.
> But we should be able to backpatch if there is no dependency.

No, it's a new feature and won't be back-patched.

> It will help users to get benefit of this feature for g96 and pg95 in RDS
> until they will have pg10 in RDS.

There is no need to wait for pg10 to be in RDS to use PG10's pg_dumpall
against RDS databases.  pg_dump and pg_dumpall are very intentionally
designed and intended to work against older versions of PG, so as soon
as PG10 is released you'll be able to run PG10's pg_dumpall against your
9.6 or 9.5 RDS databases.

> If It is against community policy then it is ok. I can understand.

It is against community policy to back-patch features.

Thanks!

Stephen

Commits

  1. Fix dumping role comments when using --no-role-passwords