Hallo. This is the log. This is postgresql 7.4.0.
The problem appeared after few hang-ups because of phisical memory
problem. Is there any way to recover the data?
2004-01-07 21:18:05 LOG: statistics collector process (PID 886) exited
with exit code 1
2004-01-05 15:12:23 LOG: could not create IPv6 socket: Address family not
supported by protocol
2004-01-05 15:12:26 LOG: database system shutdown was interrupted at
2004-01-07 21:18:05 EET
2004-01-05 15:12:26 LOG: checkpoint record is at 2/AC4CFD50
2004-01-05 15:12:26 LOG: redo record is at 2/AC4CFD50; undo record is at
0/0; shutdown FALSE
2004-01-05 15:12:26 LOG: next transaction ID: 703386; next OID: 2820198
2004-01-05 15:12:26 LOG: database system was not properly shut down;
automatic recovery in progress2004-01-05 15:12:26 LOG: redo starts at
2/AC4CFD90
2004-01-05 15:12:34 LOG: incorrect checksum of backup block 1 in record
at 2/AC906314
2004-01-05 15:12:34 LOG: redo done at 2/AC9042BC
2004-01-05 15:13:05 LOG: database system is ready
2004-01-05 16:22:15 LOG: could not create IPv6 socket: Address family not
supported by protocol
2004-01-05 16:22:16 LOG: database system was interrupted at 2004-01-05
15:13:05 EET
2004-01-05 16:22:17 LOG: checkpoint record is at 2/AC906314
2004-01-05 16:22:17 LOG: redo record is at 2/AC906314; undo record is at
0/0; shutdown TRUE
2004-01-05 16:22:17 LOG: next transaction ID: 703648; next OID: 2820198
2004-01-05 16:22:17 LOG: database system was not properly shut down;
automatic recovery in progress2004-01-05 16:22:17 LOG: redo starts at
2/AC906354
2004-01-05 16:22:19 PANIC: heap_insert_redo: invalid max offset number
2004-01-05 16:22:19 LOG: startup process (PID 854) was terminated by
signal 6
2004-01-05 16:22:19 LOG: aborting startup due to startup process failure
2004-01-07 15:59:31 LOG: could not create IPv6 socket: Address family not
supported by protocol
2004-01-07 15:59:31 LOG: database system was interrupted while in
recovery at 2004-01-05 16:22:17 EET
HINT: This probably means that some data is corrupted and you will have
to use the last backup for recovery.
2004-01-07 15:59:31 LOG: checkpoint record is at 2/AC906314
2004-01-07 15:59:31 LOG: redo record is at 2/AC906314; undo record is at
0/0; shutdown TRUE
2004-01-07 15:59:31 LOG: next transaction ID: 703648; next OID: 2820198
2004-01-07 15:59:31 LOG: database system was not properly shut down;
automatic recovery in progress2004-01-07 15:59:31 LOG: redo starts at
2/AC906354
2004-01-07 15:59:31 PANIC: heap_insert_redo: invalid max offset number
2004-01-07 15:59:31 LOG: startup process (PID 28338) was terminated by
signal 6
2004-01-07 15:59:31 LOG: aborting startup due to startup process failure
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
