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/