Re: Getting FATAL: terminating connection due to administrator command

From: Peter Hopfgartner <peter(dot)hopfgartner(at)r3-gis(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting FATAL: terminating connection due to administrator command
Date: 2010-09-15 20:11:26
Message-ID: 20100915201126.110611678215@mail.r3-gis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--------Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote--------
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to administrator command
Date: 15.09.2010 17:40

>Peter Hopfgartner <peter(dot)hopfgartner(at)r3-gis(dot)com> writes:
>> --------Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote--------
>>> This is a result of something sending SIGTERM to the backend process.
>
>> Can I trace where the SIGTERM comes from?
>
>If this is a recent Red-Hat-based release, I think that systemtap could
>probably be used to determine that. There's a script here that solves
>a related problem:
>http://sourceware.org/systemtap/examples/process/sigmon.stp
>
> regards, tom lane
>

As it seems I need to recompile the kernel in order to have the debug infos, http://sourceware.org/systemtap/wiki/SystemTapOnCentOS.
Tomorrow I will start the probes.

Thanks,
Peter

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Brinkman 2010-09-15 20:12:08 searchpath reverts to default after each server restart
Previous Message Merlin Moncure 2010-09-15 19:55:26 Re: Data Model Advice