From: | Peter Hopfgartner <peter(dot)hopfgartner(at)r3-gis(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Getting FATAL: terminating connection due to administrator command |
Date: | 2010-09-15 12:55:39 |
Message-ID: | 20100915125539.2CEFE167821F@mail.r3-gis.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
Since some days we are getting the above message.
The system is a current CentOS 5.5, x86_64, Postgresql 8.4 as it comes with the packages postgresql84, postgresql84-libs etc. PostGIS is enabled, as it comes from http://www.argeo.org/linux/argeo-el.
The error message appears from time to time. The exact same request, coming from a PHP applications, sometimes works, sometimes fails. This happens in different points of our applications, tipically, but not only, when large data portions are queried, as in geometric queries, using PostGIS.
The server is only slightly loaded.
Also in the PostgreSQL logs we get:
FATAL: terminating connection due to administrator command
repeated multiple times.
The server is from Dell, Dell's hardware monitoring, OpenManage, says that the hardware, in particular memory and disk, are ok.
We do have a nearly identical server, with the identical version of PostgreSQL/PostGIS, but that was last updated one or two months ago and which is intensly used as our testing and development server, which never gave us the same error message.
Where could I start to troubleshoot this problem.
Peter Hopfgartner
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-09-15 13:33:00 | Re: Force ARE in regexp string |
Previous Message | Bremer, Gerd | 2010-09-15 12:42:50 | Upload latest JDBC driver releases to Maven Central |