Data recovery!

From: avalon(at)dolphin-3(dot)bg
To: pgsql-general(at)postgresql(dot)org
Subject: Data recovery!
Date: 2004-01-14 14:41:09
Message-ID: 59192.212.39.81.130.1074091269.squirrel@webmail.dolphin-3.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-01-14 14:54:47 Re: What are nested transactions then? was Nested
Previous Message Francisco Reyes 2004-01-14 14:36:10 Re: Rights in 7.4