From: | mmiranda(at)americatel(dot)com(dot)sv |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Fatal error |
Date: | 2005-04-29 22:07:26 |
Message-ID: | 76E0DAA32C39D711B6EC0002B364A6FA0445C35B@amsal01exc01.americatel.com.sv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi , my server crashed this morning, aparently by a power failure, postgres
refeses to start, this is the boot log
LOG: database system was interrupted being in recovery at 2005-04-29
14:10:43 CST
This probably means that some data blocks are corrupted
and you will have to use the last backup for recovery.
LOG: checkpoint record is at F1/A0A4E05C
LOG: redo record is at F1/A0A4E05C; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 98967076; next oid: 151578857
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at F1/A0A4E09C
PANIC: Invalid page header in block 68122 of 17006
LOG: startup process (pid 1959) was terminated by signal 6
LOG: aborting startup due to startup process failure
What can i do to repair the DB, only dump/restore?, i hav tried that, but
the dump file is 14G and linux redhat 7.3 complains with file too large.
suggestions?
thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Lester | 2005-04-29 22:11:07 | Re: Postgres filling up hard drive with swap files |
Previous Message | typing80wpm | 2005-04-29 22:07:07 | success with p2p ip connection |