Data recovery! - Mailing list pgsql-general
From | avalon@dolphin-3.bg |
---|---|
Subject | Data recovery! |
Date | |
Msg-id | 59192.212.39.81.130.1074091269.squirrel@webmail.dolphin-3.bg Whole thread Raw |
Responses |
Re: Data recovery!
|
List | pgsql-general |
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
pgsql-general by date: