Re: pg_dumpall fails

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dumpall fails
Дата
Msg-id 9642.1033184280@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dumpall fails  (Willy Wonka <lunchtime@onethirty.org>)
Ответы pg_dumpall / restore issues  (Derek Neighbors <derek@gnue.org>)
Re: pg_dumpall fails  (Willy Wonka <lunchtime@onethirty.org>)
Список pgsql-admin
Willy Wonka <lunchtime@onethirty.org> writes:
> i don't know what my brother has been doing on the other end, but
> pg_dumpall now returns this:

> SELECT nextval ('"art_links_id_seq"');
> dumpSequence(submissions_submission_id_seq): different sequence name
> returned by SELECT: submissions_n_submission_id_seq

What he's been doing is renaming sequences ... pg_dump doesn't like
that, for no particularly good reason :-(.  (This gratuitous failure
is gone in 7.3, but that doesn't help you much today.)  I'd suggest
dropping and recreating the sequence, then using setval() to set its
current value correctly.  Then you should be able to pg_dump.

            regards, tom lane


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: old db on a new system
Следующее
От: "shreedhar"
Дата:
Сообщение: Pg_acl check Invalid userid 106