[GENERAL] recovery after segmentation fault

2009-04-08 Thread Ivan Sergio Borgonovo
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

Re: [GENERAL] recovery after segmentation fault

2009-04-08 Thread Tom Lane
Ivan Sergio Borgonovo m...@webthatworks.it writes: 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 Hmm, what Postgres version is this? Can you get a stack

Re: [GENERAL] recovery after segmentation fault

2009-04-08 Thread Ivan Sergio Borgonovo
On Wed, 08 Apr 2009 10:59:54 -0400 Tom Lane t...@sss.pgh.pa.us wrote: Ivan Sergio Borgonovo m...@webthatworks.it writes: 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

Re: [GENERAL] recovery after segmentation fault

2009-04-08 Thread Martijn van Oosterhout
On Wed, Apr 08, 2009 at 05:24:08PM +0200, Ivan Sergio Borgonovo wrote: How on Debian? Debian does all it's automagic stuff in init. I never learned how to start pg manually. What might be easier is turning on core dumps (ulimit -S -c unlimited) and then start postgres and see if it drops a

Re: [GENERAL] recovery after segmentation fault

2009-04-08 Thread Ivan Sergio Borgonovo
On Wed, 8 Apr 2009 23:59:43 +0200 Martijn van Oosterhout klep...@svana.org wrote: What might be easier is turning on core dumps (ulimit -S -c unlimited) and then start postgres and see if it drops a core thanks. Is there a way to just kill recovery for one DB? Just don't start it at all?

Re: [GENERAL] recovery after segmentation fault

2009-04-08 Thread Craig Ringer
Martijn van Oosterhout wrote: On Wed, Apr 08, 2009 at 05:24:08PM +0200, Ivan Sergio Borgonovo wrote: How on Debian? Debian does all it's automagic stuff in init. I never learned how to start pg manually. What might be easier is turning on core dumps (ulimit -S -c unlimited) and then start