recovery after segmentation fault - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject recovery after segmentation fault
Date
Msg-id 20090408164703.08ccdd83@dawn.webthatworks.it
Whole thread Raw
Responses Re: recovery after segmentation fault
List pgsql-general
postgresql suddenly died...

during recovery

2009-04-08 16:35:34 CEST FATAL:  the database system is starting up
^^^ several
2009-04-08 16:35:34 CEST LOG:  incomplete startup packet
2009-04-08 16:36:53 CEST FATAL:  the database system is starting up
2009-04-08 16:36:53 CEST LOG:  startup process (PID 3176) was
terminated by signal 11: Segmentation fault 2009-04-08 16:36:53 CEST
LOG:  aborting startup due to startup process failure

It could be something wrong with the recovery process in an aborted
transaction that is causing the segfault...

How can I resurrect the server and load a backup?
It was serving more than one DB and I assume that only one is
causing problems. Can I skip just that one from recovery and start
from backup?

thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: Now I am back, next thing. Final PGS tuning.
Next
From: Jennifer Trey
Date:
Subject: Re: Now I am back, next thing. Final PGS tuning.