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

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