Re: pg crashing - Mailing list pgsql-general

From Magnus Hagander
Subject Re: pg crashing
Date
Msg-id 486B93FF.6030501@hagander.net
Whole thread Raw
In response to Re: pg crashing  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
Responses Re: pg crashing
Re: pg crashing
List pgsql-general
Roberts, Jon wrote:
>> Not having looked at the internals of db_link, I'd say it's certainly
>> possible that this is the reason for the failed restart. If db_link is
>> blocking something, the postmaster can't kill it off, and it'll still
> be
>> sitting there holding a reference to the shared memory segment.
>>
>> That said, it shouldn't be the reason why it's crashing in the first
>> place - just the reason why it won't restart properly.
>>
>
> Is this a problem in Unix?  We are about 1 - 2 weeks away from moving
> this database to Solaris.

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.

//Magnus

pgsql-general by date:

Previous
From: "Roberts, Jon"
Date:
Subject: Re: pg crashing
Next
From: Tom Lane
Date:
Subject: Re: Memory Problem