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: 4BAFBB6B9CC46F41B2AD7D9F4BBAF78508C8AF@vt-pe2550-001.vantage.vantage.com (view raw or flat)
Thread:
Lists: pgsql-admin
Same error again.
 
What would be the other option? Dump the tables individually and restore
them?
 
Thanks,
Anjan

	-----Original Message-----
	From: V i s h a l Kashyap @ [Sai Hertz And Control Systems]
[mailto:sank89(at)sancharnet(dot)in] 
	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
backups/access/data.pg
		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/data.pg
	

		
		
		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,
	http://saihertz.rediffblogs.com
	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 )
	----------------o0o-----o0o---------------------

Responses

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-2014 The PostgreSQL Global Development Group