Horton
Menu

Weird pg_dumpall bug?

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Hackers <pgsql-hackers@postgresql.org>
Date: 2006-01-24T08:21:47Z
Lists: pgsql-hackers 
I did a dump of a 7.4.11 database using the 8.1.2 pg_dumpall.  I got 
this at the top of the dump:

...
...
CREATE ROLE support;
ALTER ROLE support WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB 
LOGIN PASSWORD 'md5xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';
...
...
CREATE ROLE support;
ALTER ROLE support WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
...
...

It dumped the "support" role twice!

Any ideas?

Hmmmm...actually.  It's because I have a user called 'support' and a 
group called 'support'.

Seems like it needs a fix...

Chris