Some additional info. We repeated the test on different hardware with
unfortunately the same result. This is the output of the postgresql
logfile of that experiment:
LOG: background writer process (PID 8208) was terminated by signal 9
LOG: terminating any other active server processes
LOG: statistics collector process (PID 8209) was terminated by signal 9
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2006-01-18 11:25:34 CET
LOG: checkpoint record is at 3/AE5CF484
LOG: redo record is at 3/AE5CB388; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 10061; next OID: 25648
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 3/AE5CB388
LOG: record with zero length at 3/AE5E7314
LOG: redo done at 3/AE5E72D0
LOG: database system is ready
This time we tested with postgresql 8.0.3 on a 2.6.12 linux kernel.
(Previously i tested with postgresql 7.4.9 on a 2.6.15 kernel.)
I think you will be able to repeat the experiment with this information.
Regards,
Steven
