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.
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? |