Re: pg crashing - Mailing list pgsql-general

From Tom Lane
Subject Re: pg crashing
Date
Msg-id 12227.1215013939@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg crashing  (Magnus Hagander <magnus@hagander.net>)
Responses Re: pg crashing
List pgsql-general
Magnus Hagander <magnus@hagander.net> writes:
> Not likely, but I'd test it anyway. If the issue is related to AV, it's
> certainly fine - you won't be running AV on your Solaris. But more
> importantly, Unix has actual support for signals and not just the fake
> stuff we have on Win32, so it's likely that the postmaster will be
> capable of killing the child processes.

I'm not sure what failure mode you're imagining, but the postmaster has
already verified that all the children that are supposed to be connected
to shared memory are dead before it attempts to recreate shared memory.
So the above sounds completely bogus.

I'm still suspicious of the syslogger holding onto an inherited handle
to the shared-memory file, though that theory would seem to mean that
crash recovery would never work at all on Windows if the syslogger
were enabled.  But maybe there is some additional gating factor needed
to cause the problem to manifest.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump - lost synchronization with server: got message type "d", length 6036499
Next
From: Magnus Hagander
Date:
Subject: Re: pg crashing