Re: Postgres 9.2.8 crash sporadically on Windows

Hello,

On 2014-04-07 09:49:09 -0500, Sofer, Yuval wrote:
> Postgres server (9.2.8) crash on Windows sporadically
>
> Usually it happens after machine reboot that we do, once in a day
>
> After ~4 minutes it crashes with this error in the log:
>
> 2014-04-06 08:08:01.069 GMTLOG: server process (PID 5304) exited with exit code 0
> 2014-04-06 08:08:01.069 GMTLOG: terminating any other active server processes
> 2014-04-06 08:08:01.833 GMTLOG: all server processes terminated; reinitializing
> 2014-04-06 08:08:11.183 GMTFATAL: pre-existing shared memory block is still in use
> 2014-04-06 08:08:11.183 GMTHINT: Check if there are any old server processes still running, and terminate them.
>
> This is production, Please help!

This is unfortunately not giving us many details to work with...

Are you using any self written functions? Any extensions? What's the
last query executed before the crash?

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services