Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin


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

Thanks in advance.




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.



pgsql-admin by date

Next:From: Michael FuhrDate: 2005-08-21 22:41:33
Subject: Re: sleep?
Previous:From: Guido BarosioDate: 2005-08-21 21:09:49
Subject: Re: sleep?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group