Re: Can't pg_dumpall, claims database exists twice

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Can't pg_dumpall, claims database exists twice
Дата
Msg-id 28985.1112024119@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Can't pg_dumpall, claims database exists twice  (Scott Ribe <scott_ribe@killerbytes.com>)
Ответы Re: Can't pg_dumpall, claims database exists twice  (Scott Ribe <scott_ribe@killerbytes.com>)
Список 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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Parallel Query should be a top priority
Следующее
От: Thomas F.O'Connell
Дата:
Сообщение: Re: Referential integrity using constant in foreign key