X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EF13FD1CCCD for ; Thu, 26 Feb 2004 17:55:46 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 29770-01 for ; Thu, 26 Feb 2004 13:55:39 -0400 (AST) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id C318FD1BA22 for ; Thu, 26 Feb 2004 13:55:37 -0400 (AST) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) id <0HTP00001DF64V@ndl1mr1-a-fixed.sancharnet.in> for pgsql-admin@postgresql.org; Thu, 26 Feb 2004 23:23:03 +0530 (IST) Received: from sancharnet.in ([61.0.95.107]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) with ESMTPA id <0HTP00EUYDOAO4@ndl1mr1-a-fixed.sancharnet.in>; Thu, 26 Feb 2004 23:23:03 +0530 (IST) Date: Thu, 26 Feb 2004 23:41:38 +0530 From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]" Subject: Re: pg_restore data block error In-reply-to: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098028@vt-pe2550-001.vantage.vantage.com> To: Anjan Dave Cc: pgsql-admin@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <403E36DA.3050508@sancharnet.in> Organization: Sai Hertz And Control Systems Pvt Ltd MIME-version: 1.0 Content-type: multipart/alternative; boundary="Boundary_(ID_CZM4Lzzyj+Ggus0r6asuGA)" X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098028@vt-pe2550-001.vantage.vantage.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/361 X-Sequence-Number: 12535 This is a multi-part message in MIME format. --Boundary_(ID_CZM4Lzzyj+Ggus0r6asuGA) Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT 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@jabber.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--------------------- --Boundary_(ID_CZM4Lzzyj+Ggus0r6asuGA) Content-type: text/html; charset=us-ascii Content-transfer-encoding: 7BIT Dear Anjan Dave  ,
Message
-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@jabber.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---------------------
--Boundary_(ID_CZM4Lzzyj+Ggus0r6asuGA)--