Re: error on CREATE INDEX when restoring from dump file: could not read block 0

Поиск
Список
Период
Сортировка
От Vincent Veyron
Тема Re: error on CREATE INDEX when restoring from dump file: could not read block 0
Дата
Msg-id 20150928181006.d97134b64d371d14aaf515d7@wanadoo.fr
обсуждение исходный текст
Ответ на Re: error on CREATE INDEX when restoring from dump file: could not read block 0  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On Sun, 27 Sep 2015 14:34:24 -0700
Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>

Hi Adrian

> What are your pg_dump/pg_restore commands?
>
> Are you using the 9.4 version of pg_dump to dump the 9.1 server or the
> 9.1 version?
>

Combinations of all these, always the same result.


> Hmm, just had a thought. Wonder if it is a dependency issue with what
> dossier_contrat expects to see loaded prior to its creation?

Yes, apparently due to a change since 9.3, explained by Tom here :


http://www.postgresql.org/message-id/flat/87tx0dc80x.fsf@news-spur.riddles.org.uk#87tx0dc80x.fsf@news-spur.riddles.org.uk


--
                    Bien à vous, Vincent Veyron

https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats pour le service juridique


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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: WAL Shipping and streaming replication
Следующее
От: Vincent Veyron
Дата:
Сообщение: Re: error on CREATE INDEX when restoring from dump file: could not read block 0