Re: pg_restore problem "Found unexpected Block id"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "ramana(dot)pls" <ramana(dot)pls(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore problem "Found unexpected Block id"
Date: 2012-09-12 14:24:53
Message-ID: 24833.1347459893@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"ramana.pls" <ramana(dot)pls(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2012-09-12 14:25:55 Re: pg_restore problem "Found unexpected Block id"
Previous Message Thomas Kellerer 2012-09-12 10:03:21 Re: Missing loadable libraries when running pg_upgrade 9.1 -> 9.2