Fatal error - Mailing list pgsql-general

From mmiranda@americatel.com.sv
Subject Fatal error
Date
Msg-id 76E0DAA32C39D711B6EC0002B364A6FA0445C35B@amsal01exc01.americatel.com.sv
Whole thread Raw
Responses Re: Fatal error  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-general by date:

Previous
From: Joe Lester
Date:
Subject: Re: Postgres filling up hard drive with swap files
Next
From: Mike Nolan
Date:
Subject: Re: Tuning queries inside a function