ohp@pyrenet.fr writes:
> I've have a MAJOR crash an hour ago and postgresql doesn't start anymoe
> (version 7.3.4).
> Oct 30 17:16:21 server postgres[4135]: [7] PANIC: Invalid page header in block 6157 of 29135442
> Oct 30 17:16:21 server postgres[4132]: [1] LOG: startup process (pid 4135) was terminated by signal 6
> Oct 30 17:16:21 server postgres[4132]: [2] LOG: aborting startup due to startup process failure
> Is there anything I can do not to reload all backups?
You could try turning on zero_damaged_pages in postgresql.conf. If you
are lucky, the page in question is going to be rewritten from WAL anyway.
regards, tom lane