Skip site navigation (1) Skip section navigation (2)

Re: pg_restore data block error

From: "V i s h a l Kashyap (at) [Sai Hertz And Control Systems]" <sank89(at)sancharnet(dot)in>
To: Anjan Dave <adave(at)vantage(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore data block error
Date: 2004-02-26 18:11:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Dear Anjan Dave  ,

> -bash-2.05b$ pg_restore -a -d access backups/access/
> pg_restore: [custom archiver] could not read data block -- expected 
> 4096, got 3608

To me this seems as a error in file format.
Anyways try using the following
pg_restore --disable-triggers -i -a -d access backups/access/

> I am dumping from 7.2.4 (RH8 - RAID5 set) to 7.4.0 (RH9).

use  -i switch for restore of data
Kindly shootback it this helps

Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
Jabber IM: vishalkashyap(at)jabber(dot)org
ICQ :      264360076
You yourself, as much as anybody in the entire 
universe, deserve your love and affection.
- Buddha
I am usually called by the name Vishal Kashyap
and my Girlfriend calls me Vishal CASH UP.
This is because everyone loves me as Vishal Kashyap
and my Girlfriend loves me as CASH.
                  ( 0_0 )

In response to

pgsql-admin by date

Next:From: Jeff BoesDate: 2004-02-26 20:10:15
Subject: un-CLUSTER?
Previous:From: Mark GibsonDate: 2004-02-26 16:42:59
Subject: Any Gentoo users interested in a slotted PostgreSQL ebuild?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group