Re: Please help

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