From: | Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_restore fails for postgis data dump |
Date: | 2008-02-01 14:40:41 |
Message-ID: | 4F79CA9B-9E2C-4937-88E5-189ED9549640@grid.unep.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi there,
I just wanted to restore a dump which I did, which includes some
postgis data. But, it doesn't work and instead I get this error message:
pg_restore: restoring data for table "boundaries_national"
pg_restore: [archiver (db)] error returned by PQputCopyData: server
closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_restore: *** aborted because of error
The log shows this:
__________________________________________________________________
LOG: server process (PID 737) was terminated by signal 10
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back
the current transaction and exit, because another server process
exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2008-02-01 15:07:12 CET
LOG: checkpoint record is at 0/FC56620C
LOG: redo record is at 0/FC56620C; undo record is at 0/0; shutdown
FALSE
LOG: next transaction ID: 0/8880241; next OID: 9551872
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system was not properly shut down; automatic recovery
in progress
LOG: redo starts at 0/FC566254
LOG: record with zero length at 0/FC7435DC
LOG: redo done at 0/FC7435B4
LOG: database system is ready
__________________________________________________________________
What does it mean? The dump is from a 8.1 database, whereas the new
one is 8.2. There is surely as well some difference in postgis
version. Can it be linked to that? I am working with Leopard.
Thanks for any advice.
Stef
____________________________________________________________________
Lean Back and Relax - Enjoy some Nature Photography
http://photoblog.la-famille-schwarzer.de
Appetite for Global Data? UNEP GEO Data Portal:
http://geodata.grid.unep.ch
____________________________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2008-02-01 14:53:42 | Re: arrays of floating point numbers / linear algebra operations into the DB |
Previous Message | Yuriy Rusinov | 2008-02-01 14:36:23 | Complex query optimization |