Ed Loehr <[EMAIL PROTECTED]> writes:
> Is there any circumstance at all under which pgsql itself would
> issue a sigkill to one of the backends?
No. Other signals yes, but not SIGKILL.
regards, tom lane
---(end of broadcast)--
On Wednesday November 8 2006 12:30 pm, Shoaib Mir wrote:
> To be specific you need to look at the syslogs to see if it
> was actually some OOM killer or not.
I checked all db logs + syslog, of course. All they show is the
process receiving SIGKILL (followed by all others being shutdown
as a res
Look at the database server logs and see what actually was happening just before the server crashed... do you have the auto vacuuming running at backend? or was there some client making connection just when the server did crash? your db logs can actually help you here.
Thank you,---Sho
On Thu, Nov 09, 2006 at 11:52:48AM +0500, Shoaib Mir wrote:
> Have a look at "16.4.3. Linux Memory Overcommit" on
> http://www.postgresql.org/docs/8.1/interactive/kernel-resources.html
If you look at the beginning of the thread you'dve seen we're talking
about HPUX here...
Maybe they have an OOM
Have a look at "16.4.3. Linux Memory Overcommit" on http://www.postgresql.org/docs/8.1/interactive/kernel-resources.htmlThanks,
--Shoaib MirEnterpriseDB (www.enterprisedb.com)On 11/9/06, Talha Khan <
[EMAIL PROTECTED]> wrote:Hi Ed,I don't think its pgsql thats sending the SIGKILL its being done
Hi Ed,I don't think its pgsql thats sending the SIGKILL its being done by the OS. The reason can only be confirmed after looking at your log files but the probability is that your OS ran out of memory and in order to protect itself it had to kill the processes that were taking a lot of memory thus
To be specific you need to look at the syslogs to see if it was actually some OOM killer or not.Thanks,---Shoaib MirEnterpriseDB (www.enterprisedb.com)
On 11/9/06, Talha Khan <[EMAIL PROTECTED]> wrote:
Hi Ed,You need to look through the log files for details.RegardsTalha KhanOn 11/8/06,
Ed L.
Hi Ed,You need to look through the log files for details.RegardsTalha KhanOn 11/8/06, Ed L. <
[EMAIL PROTECTED]> wrote:One of our 8.1.2 postmasters on HPUX 11.23 ia64 just received a
SIGKILL signal from unknown origins. After reviewing allcommand history files for the DBA and root, I do not believ
One of our 8.1.2 postmasters on HPUX 11.23 ia64 just received a
SIGKILL signal from unknown origins. After reviewing all
command history files for the DBA and root, I do not believe
anyone manually sent it, and we have no scripts etc that would
do that, at least that we can find or imagine.
