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

From Tom Lane
Subject Re: Can't pg_dumpall, claims database exists twice
Date
Msg-id 28985.1112024119@sss.pgh.pa.us
Whole thread Raw
In response to Can't pg_dumpall, claims database exists twice  (Scott Ribe <scott_ribe@killerbytes.com>)
Responses Re: Can't pg_dumpall, claims database exists twice  (Scott Ribe <scott_ribe@killerbytes.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Parallel Query should be a top priority
Next
From: Thomas F.O'Connell
Date:
Subject: Re: Referential integrity using constant in foreign key