Re: [ADMIN] New message pg_dumpall role skiped ??? - Mailing list pgsql-admin

From Jorge Torralba
Subject Re: [ADMIN] New message pg_dumpall role skiped ???
Date
Msg-id CACut7uQp44Cxx1p0L9aRMQBXGX3jXgNGq0MtXcxJ5GPsjQszkQ@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] New message pg_dumpall role skiped ???  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
Thank you !

On Tue, Jan 31, 2017 at 9:28 AM, Stephen Frost <sfrost@snowman.net> wrote:
Greetings Jorge,

* Jorge Torralba (jorge.torralba@gmail.com) wrote:
> pg_dumpall: role name starting with "pg_" skipped

That message should also tell you what the role name was which was
skipped by pg_dumpall.

> Looking at the source looks like it was committed back in April.
>
> What was the reason for this and can the messages be suppressed?

This was added because it means that a role which exists in your pre-9.6
version of PG begins with "pg_" and is not included in the pg_dumpall
output.

The best way to address this is to rename your role to not include the
"pg_" prefix as that prefix is now reserved for system-defined roles
(just like schemas).

Thanks!

Stephen



--
Thanks,

Jorge Torralba
----------------------------

Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.

pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [ADMIN] New message pg_dumpall role skiped ???
Next
From: John Scalia
Date:
Subject: [ADMIN] building 9.6.1 with a different value for krb-srvnam