$ sudo -u postgres pg_restore -d mydatabase -j8 mydatabase.dmp
I've now tried five times, and gotten five failures. (I've tries setting --jobs to smaller values, including not specifying anything at all.) Here's the postgres error log from the last failure:
2011-04-04 23:07:00 EDT LOG: server process (PID 7632) was terminated by signal 11: Segmentation fault
2011-04-04 23:07:00 EDT LOG: terminating any other active server processes
2011-04-04 23:07:00 EDT WARNING: terminating connection because of crash of another server process
2011-04-04 23:07:00 EDT 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.
2011-04-04 23:07:00 EDT HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011-04-04 23:07:00 EDT WARNING: terminating connection because of crash of another server process
2011-04-04 23:07:00 EDT 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.
2011-04-04 23:07:00 EDT HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011-04-04 23:07:00 EDT CONTEXT: COPY transactions, line 10629187
2011-04-04 23:07:00 EDT WARNING: terminating connection because of crash of another server process
2011-04-04 23:07:00 EDT 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.
2011-04-04 23:07:00 EDT HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011-04-04 23:07:00 EDT WARNING: terminating connection because of crash of another server process
2011-04-04 23:07:00 EDT 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.
2011-04-04 23:07:00 EDT HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011-04-04 23:07:00 EDT FATAL: the database system is in recovery mode
2011-04-04 23:07:00 EDT LOG: all server processes terminated; reinitializing
2011-04-04 23:07:00 EDT LOG: database system was interrupted; last known up at 2011-04-04 23:06:25 EDT
2011-04-04 23:07:00 EDT LOG: database system was not properly shut down; automatic recovery in progress
2011-04-04 23:07:00 EDT LOG: consistent recovery state reached at 19/6E524410
2011-04-04 23:07:00 EDT LOG: redo starts at 19/6E175B68
2011-04-04 23:07:00 EDT LOG: unexpected pageaddr 18/425D6000 in log file 25, segment 110, offset 6119424
2011-04-04 23:07:00 EDT LOG: redo done at 19/6E5D5F90
2011-04-04 23:07:00 EDT LOG: last completed transaction was at log time 2011-04-04 23:06:16.684615-04
2011-04-04 23:07:01 EDT LOG: database system is ready to accept connections
2011-04-04 23:07:01 EDT LOG: autovacuum launcher started
And in /var/log/messages, I have the following (last line is for this crash, previous lines for previous crashes):
Apr 4 21:27:27 mu kernel: [ 1964.787667] do_general_protection: 24 callbacks suppressed
Apr 4 21:27:27 mu kernel: [ 1964.787671] postgres[3439] general protection ip:7f8372c8d2f7 sp:7fff61b72b38 error:0 in postgres[7f8372973000+4a8000]
Apr 4 21:32:21 mu kernel: [ 2258.266116] postgres[4307]: segfault at 30 ip 00007f8372c8d2fb sp 00007fff61b72bd8 error 4 in postgres[7f8372973000+4a8000]
Apr 4 21:47:27 mu kernel: [ 3164.740812] postgres[5040]: segfault at 40 ip 00007f8372c8d2fb sp 00007fff61b72b38 error 4 in postgres[7f8372973000+4a8000]
Apr 4 22:03:12 mu kernel: [ 4108.987420] postgres[5077]: segfault at 40 ip 00007f8372c8d2fb sp 00007fff61b72978 error 4 in postgres[7f8372973000+4a8000]
Apr 4 22:56:13 mu kernel: [ 7288.639099] postgres[5308] general protection ip:7f8372c8d2f7 sp:7fff61b72748 error:0 in postgres[7f8372973000+4a8000]
Apr 4 23:07:00 mu kernel: [ 7935.670820] postgres[7632]: segfault at 7365 ip 00007f8372c8c94e sp 00007fff61b72ad0 error 4 in postgres[7f8372973000+4a8000]
This is on Ubuntu 10.10 server, 64-bit on Intel. I'm running Postgres 9.0.3, 64-bit from the ppa repository.
What can I do to help the developers find the root cause of this? I'm happy to run a debug version, or find a corefile, or whatever I can, but I might need some guidance, as I'm pretty new to postgres.
-Chris
--
Ignoring that little voice in my head since 1966!
