Re: error on CREATE INDEX when restoring from dump file: could not read block 0 - Mailing list pgsql-general

From Vincent Veyron
Subject Re: error on CREATE INDEX when restoring from dump file: could not read block 0
Date
Msg-id 20150928181006.d97134b64d371d14aaf515d7@wanadoo.fr
Whole thread Raw
In response to Re: error on CREATE INDEX when restoring from dump file: could not read block 0  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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 by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: WAL Shipping and streaming replication
Next
From: Vincent Veyron
Date:
Subject: Re: error on CREATE INDEX when restoring from dump file: could not read block 0