> 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:  PANIC: Invalid page header in block 6157 of 29135442
> Oct 30 17:16:21 server postgres:  LOG: startup process (pid 4135) was terminated by signal 6
> Oct 30 17:16:21 server postgres:  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
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2003-10-30 22:34:14|
|Subject: Re: CREATE TYPE for case insensitive text and varchar |
|Previous:||From: Jan Wieck||Date: 2003-10-30 21:48:03|
|Subject: Re: pg_user|