Data recovery!

Started by Nonameover 22 years ago2 messagesgeneral
Jump to latest
#1Noname
avalon@dolphin-3.bg

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: Data recovery!

avalon@dolphin-3.bg writes:

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?

Well, since the WAL log is clearly corrupt, you might as well do
pg_resetxlog. Don't have a lot of faith in the validity of your
database afterwards though --- I'd suggest a dump and reload plus
as much manual cross-checking as you can think of.

regards, tom lane