Andres Freund <andres@2ndquadrant.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