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:

Previous
From: "LitelWang"
Date:
Subject: about postgres odbc on wondows
Next
From: Christopher Browne
Date:
Subject: Re: What Version Installed?