X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DB6AAD8551 for ; Tue, 30 Aug 2005 15:11:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26834-06 for ; Tue, 30 Aug 2005 18:11:49 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 47420D6F02 for ; Tue, 30 Aug 2005 15:11:46 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 30 Aug 2005 13:11:45 -0500 Subject: Re: DB restore fails W2k. From: Scott Marlowe To: Dan Cc: pgsql-admin@postgresql.org In-Reply-To: <20050821211646.NPNT11566.amsfep12-int.chello.nl@tdb> References: <20050821211646.NPNT11566.amsfep12-int.chello.nl@tdb> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1125425504.28179.69.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 30 Aug 2005 13:11:45 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 required=5 tests=[AWL=0.004] X-Spam-Level: X-Archive-Number: 200508/391 X-Sequence-Number: 18710 On Sun, 2005-08-21 at 16:16, Dan wrote: > Hello, >=20 > =20 >=20 > We have upgraded our PostgreSQL database version from 7.3.1 (Cygwin) > under Windows 2000 server to v8.03 for windows.=20 >=20 > =20 >=20 > Now we dumped our database (app. size 6 GB) with PgAdmin III with > success. The problem now is that we can=E2=80=99t completely restore our > database with the dump file. The restore utility just stops when > reaching a certain point in the dump file. >=20 > Please help us, we can=E2=80=99t afford loosing our database with several > years of work. >=20 > Thanks in advance. >=20 > =20 >=20 > /Dan >=20 > =20 >=20 > Here is some info on the dump file: >=20 > ; Archive created at Wed Aug 17 21:09:56 2005 >=20 > ; dbname: a_db >=20 > ; TOC Entries: 43 >=20 > ; Compression: -1 >=20 > ; Dump Version: 1.10-0 >=20 > ; Format: CUSTOM >=20 > ; Integer: 4 bytes >=20 > ; Offset: 4 bytes >=20 > ; Dumped from database version: 7.3.1 >=20 > ; Dumped by pg_dump version: 8.0.0 >=20 > =20 >=20 > Error displayed when restoring. >=20 > C:\Program Files\PostgreSQL\8.0\pgAdmin III\pg_restore.exe -i -h > localhost -p 5432 -U postgres -d a_db -a -t pictures -v > "D:\a_db.backup" >=20 > pg_restore: connecting to database for restore >=20 > pg_restore: restoring data for table " pictures" >=20 > pg_restore: [custom archiver] error during file seek: Invalid argument >=20 > pg_restore: *** aborted because of error >=20 > =20 >=20 > Process returned exit code 1. Have you tried using psql to restore? This almost sounds like you're hitting a file size limit somewhere, like the 2 gig file size limit linux kernels suffered from years ago.