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

From: Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: error on CREATE INDEX when restoring from dump file: could not read block 0
Date: 2015-09-28 16:10:06
Message-ID: 20150928181006.d97134b64d371d14aaf515d7@wanadoo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 27 Sep 2015 14:34:24 -0700
Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(dot)fsf(at)news-spur(dot)riddles(dot)org(dot)uk#87tx0dc80x(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Veyron 2015-09-28 16:15:55 Re: error on CREATE INDEX when restoring from dump file: could not read block 0
Previous Message hubert depesz lubaczewski 2015-09-28 15:28:35 Re: WAL Shipping and streaming replication