Re: Can't pg_dumpall, claims database exists twice

Scott Ribe <scott_ribe@killerbytes.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