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/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])