Re: Can't pg_dumpall, claims database exists twice - Mailing list pgsql-general

On Mon, Mar 28, 2005 at 12:51:19AM -0700, Scott Ribe wrote:
>  pg_dumpall is failing with this error:
>
> pg_dump: query returned more than one (2) pg_database entry for database
> "pedcard"
> pg_dumpall: pg_dump failed on database "pedcard", exiting
>
> This is 8.0.1 on OS X; where do I start on straightening this out? (There is
> only 1 postmaster running, and it seems OK from client apps, both my own app
> and psql.)

What's the result of the following query?

SELECT tableoid, xmin, xmax, oid, datname, datdba,
       datvacuumxid, datfrozenxid
FROM pg_database
ORDER BY datname, oid;

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/