pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg_restore data block error 5+ messages / 3 participants [nested] [flat]
* pg_restore data block error @ 2004-02-26 14:35 Anjan Dave <adave@vantage.com> 0 siblings, 1 reply; 5+ messages in thread From: Anjan Dave @ 2004-02-26 14:35 UTC (permalink / raw) To: pgsql-admin Dear All: I am trying to restore a database (size is about 7GB) from a dump file created by a simple backup script..The format is data.pg. The schema restores fine, but during the data restore, i get the following error: -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 I tried this twice now, with backups taken on different days... I am dumping from 7.2.4 (RH8 - RAID5 set) to 7.4.0 (RH9). Any ideas please? Thanks, Anjan ************************************************************************ ** This e-mail and any files transmitted with it are intended for the use of the addressee(s) only and may be confidential and covered by the attorney/client and other privileges. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited. ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_restore data block error @ 2004-02-26 18:11 V i s h a l Kashyap @ [Sai Hertz And Control Systems] <sank89@sancharnet.in> parent: Anjan Dave <adave@vantage.com> 0 siblings, 0 replies; 5+ messages in thread From: V i s h a l Kashyap @ [Sai Hertz And Control Systems] @ 2004-02-26 18:11 UTC (permalink / raw) To: Anjan Dave <adave@vantage.com>; +Cc: pgsql-admin 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--------------------- ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_restore data block error @ 2004-02-27 19:46 Anjan Dave <adave@vantage.com> 0 siblings, 1 reply; 5+ messages in thread From: Anjan Dave @ 2004-02-27 19:46 UTC (permalink / raw) To: aspire420@hotpop.com; +Cc: 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@sancharnet.in] Sent: Thursday, February 26, 2004 1:12 PM To: Anjan Dave Cc: pgsql-admin@postgresql.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@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--------------------- ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_restore data block error @ 2004-02-27 22:24 Tom Lane <tgl@sss.pgh.pa.us> parent: Anjan Dave <adave@vantage.com> 0 siblings, 0 replies; 5+ messages in thread From: Tom Lane @ 2004-02-27 22:24 UTC (permalink / raw) To: Anjan Dave <adave@vantage.com>; +Cc: aspire420@hotpop.com; pgsql-admin "Anjan Dave" <adave@vantage.com> writes: > Same error again. > -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 You said the dump file was over 4Gb, right? I'm wondering if you are running into some file-offset-size bug. In particular this recent bug fix might be relevant: 2004-01-03 23:02 tgl * src/bin/pg_dump/pg_backup_archiver.c (REL7_4_STABLE): Fix ReadOffset() to work correctly when off_t is wider than int. although offhand I'm not sure how that would translate into what sounds to be an unexpected-EOF failure. regards, tom lane ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_restore data block error @ 2004-02-27 22:28 Anjan Dave <adave@vantage.com> 0 siblings, 0 replies; 5+ messages in thread From: Anjan Dave @ 2004-02-27 22:28 UTC (permalink / raw) To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: aspire420@hotpop.com; pgsql-admin Yes, it's about 7GB. I installed it from RPMs...Do I just copy over the pg_backup_archiver.c file? Is there any easy way to dump individual tables (dealing with 73 tables)? Thanks for your response, Anjan -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Friday, February 27, 2004 5:24 PM To: Anjan Dave Cc: aspire420@hotpop.com; pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_restore data block error "Anjan Dave" <adave@vantage.com> writes: > Same error again. > -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 You said the dump file was over 4Gb, right? I'm wondering if you are running into some file-offset-size bug. In particular this recent bug fix might be relevant: 2004-01-03 23:02 tgl * src/bin/pg_dump/pg_backup_archiver.c (REL7_4_STABLE): Fix ReadOffset() to work correctly when off_t is wider than int. although offhand I'm not sure how that would translate into what sounds to be an unexpected-EOF failure. regards, tom lane ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-02-27 22:28 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-02-26 14:35 pg_restore data block error Anjan Dave <adave@vantage.com> 2004-02-26 18:11 ` V i s h a l Kashyap @ [Sai Hertz And Control Systems] <sank89@sancharnet.in> 2004-02-27 19:46 Re: pg_restore data block error Anjan Dave <adave@vantage.com> 2004-02-27 22:24 ` Tom Lane <tgl@sss.pgh.pa.us> 2004-02-27 22:28 Re: pg_restore data block error Anjan Dave <adave@vantage.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox