[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
