DB restore fails W2k.

From: "Dan" <danilos(at)home(dot)se>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: DB restore fails W2k.
Date: 2005-08-21 21:16:37
Message-ID: 20050821211646.NPNT11566.amsfep12-int.chello.nl@tdb
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

We have upgraded our PostgreSQL database version from 7.3.1 (Cygwin) under
Windows 2000 server to v8.03 for windows.

Now we dumped our database (app. size 6 GB) with PgAdmin III with success.
The problem now is that we can't completely restore our database with the
dump file. The restore utility just stops when reaching a certain point in
the dump file.

Please help us, we can't afford loosing our database with several years of
work.

Thanks in advance.

/Dan

Here is some info on the dump file:

; Archive created at Wed Aug 17 21:09:56 2005

; dbname: a_db

; TOC Entries: 43

; Compression: -1

; Dump Version: 1.10-0

; Format: CUSTOM

; Integer: 4 bytes

; Offset: 4 bytes

; Dumped from database version: 7.3.1

; Dumped by pg_dump version: 8.0.0

Error displayed when restoring.

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"

pg_restore: connecting to database for restore

pg_restore: restoring data for table " pictures"

pg_restore: [custom archiver] error during file seek: Invalid argument

pg_restore: *** aborted because of error

Process returned exit code 1.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2005-08-21 22:41:33 Re: sleep?
Previous Message Guido Barosio 2005-08-21 21:09:49 Re: sleep?