| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: New message pg_dumpall role skiped ??? |
| Date: | 2017-01-31 17:28:38 |
| Message-ID: | 20170131172837.GO9812@tamriel.snowman.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Greetings Jorge,
* Jorge Torralba (jorge(dot)torralba(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jorge Torralba | 2017-01-31 17:43:15 | Re: New message pg_dumpall role skiped ??? |
| Previous Message | Jorge Torralba | 2017-01-31 17:20:10 | New message pg_dumpall role skiped ??? |