pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNew message pg_dumpall role skiped ???
3+ messages / 2 participants
[nested] [flat]
* New message pg_dumpall role skiped ???
@ 2017-01-31 17:20 Jorge Torralba <jorge.torralba@gmail.com>
2017-01-31 17:28 ` Re: New message pg_dumpall role skiped ??? Stephen Frost <sfrost@snowman.net>
0 siblings, 1 reply; 3+ messages in thread
From: Jorge Torralba @ 2017-01-31 17:20 UTC (permalink / raw)
To: pgsql-admin
Our jenkins job is now generating errors due to new warning messages from
pg_dumpall.
We are now seeing the following:
pg_dumpall: role name starting with "pg_" skipped
Looking at the source looks like it was committed back in April.
What was the reason for this and can the messages be suppressed?
Thanks
--
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: New message pg_dumpall role skiped ???
2017-01-31 17:20 New message pg_dumpall role skiped ??? Jorge Torralba <jorge.torralba@gmail.com>
@ 2017-01-31 17:28 ` Stephen Frost <sfrost@snowman.net>
2017-01-31 17:43 ` Re: New message pg_dumpall role skiped ??? Jorge Torralba <jorge.torralba@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Stephen Frost @ 2017-01-31 17:28 UTC (permalink / raw)
To: Jorge Torralba <jorge.torralba@gmail.com>; +Cc: pgsql-admin
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
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: New message pg_dumpall role skiped ???
2017-01-31 17:20 New message pg_dumpall role skiped ??? Jorge Torralba <jorge.torralba@gmail.com>
2017-01-31 17:28 ` Re: New message pg_dumpall role skiped ??? Stephen Frost <sfrost@snowman.net>
@ 2017-01-31 17:43 ` Jorge Torralba <jorge.torralba@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jorge Torralba @ 2017-01-31 17:43 UTC (permalink / raw)
To: Stephen Frost <sfrost@snowman.net>; +Cc: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2017-01-31 17:43 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-01-31 17:20 New message pg_dumpall role skiped ??? Jorge Torralba <jorge.torralba@gmail.com>
2017-01-31 17:28 ` Stephen Frost <sfrost@snowman.net>
2017-01-31 17:43 ` Jorge Torralba <jorge.torralba@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox