Skip site navigation (1) Skip section navigation (2)

Weird pg_dumpall bug?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Weird pg_dumpall bug?
Date: 2006-01-24 08:21:47
Message-ID: 43D5E39B.2050709@familyhealth.com.au (view raw or flat)
Thread:
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


Responses

pgsql-hackers by date

Next:From: Marko KreenDate: 2006-01-24 08:40:51
Subject: Re: [PATCHES] postmaster/postgres merge for testing
Previous:From: Tino WildenhainDate: 2006-01-24 08:14:38
Subject: Re: Offer for PG Developers/Hackers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group