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

Re: pg_restore data block error

From: "Anjan Dave" <adave(at)vantage(dot)com>
To: <aspire420(at)hotpop(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_restore data block error
Date: 2004-02-27 19:46:05
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
Same error again.
What would be the other option? Dump the tables individually and restore

	-----Original Message-----
	From: V i s h a l Kashyap @ [Sai Hertz And Control Systems]
	Sent: Thursday, February 26, 2004 1:12 PM
	To: Anjan Dave
	Cc: pgsql-admin(at)postgresql(dot)org
	Subject: Re: [ADMIN] pg_restore data block error
	Dear Anjan Dave  ,

		-bash-2.05b$ pg_restore -a -d 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

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

	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 )


pgsql-admin by date

Next:From: Tom LaneDate: 2004-02-27 22:24:21
Subject: Re: pg_restore data block error
Previous:From: Jean-Michel ChabanneDate: 2004-02-27 19:14:53
Subject: Re: copying data between tables

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