Re: sequence not set with pg_restore

Поиск
Список
Период
Сортировка
От Randall Smith
Тема Re: sequence not set with pg_restore
Дата
Msg-id j2Yad.16064$_g6.11879@okepread03
обсуждение исходный текст
Ответ на sequence not set with pg_restore  (Randall Smith <randall@tnr.cc>)
Ответы Re: sequence not set with pg_restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Randall Smith wrote:
> I'm dumped a database on 7.4.0.3 using pg_restore -Fc mydb > mydb.dump.
>
> I then restored it using pg_restore -d dwstest -U dba mydb.dump on
> another server running 7.4.5-3.
>
> After importing, all of the sequences are set to 0.  Did I miss a step?
>
> Randall
As a note, using pg_dump with plain text format does not have this
problem.  So is there a bug in the custom format?

Randall

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

Предыдущее
От: Dan Hrabarchuk
Дата:
Сообщение: Re: [Fwd: zero_damaged_pages having no effect]
Следующее
От: Tom Lane
Дата:
Сообщение: Re: sequence not set with pg_restore