Re: Postgres 9.2.8 crash sporadically on Windows

Andres Freund <andres(at)2ndquadrant(dot)com> writes:
> On 2014-04-07 09:49:09 -0500, Sofer, Yuval wrote:
>> Postgres server (9.2.8) crash on Windows sporadically

>> 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...

The "exit code 0" bit reminds me of this:

http://www.postgresql.org/message-id/21027.1393546453@sss.pgh.pa.us

Is there another exit report for the same PID just above the quoted log
extract? Because if there isn't, the postmaster shouldn't be thinking
that status 0 represents a crash.

regards, tom lane