Re: Getting FATAL: terminating connection due to administrator command - Mailing list pgsql-general

From Tom Lane
Subject Re: Getting FATAL: terminating connection due to administrator command
Date
Msg-id 4564.1284559661@sss.pgh.pa.us
Whole thread Raw
In response to Getting FATAL: terminating connection due to administrator command  (Peter Hopfgartner <peter.hopfgartner@r3-gis.com>)
Responses Re: Getting FATAL: terminating connection due to administrator command  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Peter Hopfgartner <peter.hopfgartner@r3-gis.com> writes:
> Since some days we are getting the above message.
> Also in the PostgreSQL logs we get:
> FATAL:  terminating connection due to administrator command

This is a result of something sending SIGTERM to the backend process.

I have heard reports of "load management" software that SIGTERM's
processes more or less at random whenever it decides the system is
overloaded.  If you have any such junkware installed on your server,
try disabling it.

> The server is from Dell, Dell's hardware monitoring, OpenManage, says that the hardware, in particular memory and
disk,are ok. 

Never dealt with OpenManage before, but you should cast a wary eye
upon any Dell-specific software on the machine.  This behavior is
definitely not normal for Unix systems, so you need to look for
nonstandard software (and what's more, nonstandard software running with
root privileges, else it couldn't SIGTERM postgres processes).

            regards, tom lane

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Getting FATAL: terminating connection due to administrator command
Next
From: Gary Fu
Date:
Subject: Re: select sql slow inside function