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.