Scott Ribe <scott_ribe(at)killerbytes(dot)com> writes:
> 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?
"select * from pg_database" might provide some clues ... if it does in
fact show more than one row for "pedcard", it'd be useful to look at the
system columns too:
select ctid,oid,xmin,cmin,xmax,cmax,* from pg_database
regards, tom lane