Re: pg_restore problem "Found unexpected Block id" - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_restore problem "Found unexpected Block id"
Date
Msg-id 24833.1347459893@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore problem "Found unexpected Block id"  ("ramana.pls" <ramana.pls@gmail.com>)
List pgsql-admin
"ramana.pls" <ramana.pls@gmail.com> writes:
> I am getting an error while restoring the Database Backup. I am postgre sql
> 8.0 with Windows XP O.S.

8.0?  You do know that's been out of support for several years now,
right?

> while restoring the data i am getting
> pg_restore: [custom archiver] found unexpected block ID (0) when reading
> data --
>  expected 4034

This looks somewhat like a pg_restore bug we fixed awhile back.  I'd
suggest updating to a more modern Postgres version and seeing if it
works any better.

            regards, tom lane


pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Missing loadable libraries when running pg_upgrade 9.1 -> 9.2
Next
From: "Kevin Grittner"
Date:
Subject: Re: pg_restore problem "Found unexpected Block id"