Thread: 7.4: FATAL: terminating connection due to administrator command

7.4: FATAL: terminating connection due to administrator command

From
Dmitry Knyazev
Date:
Hello pgsql-bugs,

  Im using postgres 7.4 build from source on FreeBSD 4.9 with pglogd
  for storing apache logs.
  When apache load becomes moderate enough, postgres exits with message:

    FATAL:  terminating connection due to administrator command

  I tried different values of shared_buffers and sort_mem in conf
  file, but this seems not help.

--
Best regards,
 Dmitry                          mailto:dfr@wm.ru

Re: 7.4: FATAL: terminating connection due to administrator command

From
Tom Lane
Date:
Dmitry Knyazev <dfr@wm.ru> writes:
>   Im using postgres 7.4 build from source on FreeBSD 4.9 with pglogd
>   for storing apache logs.
>   When apache load becomes moderate enough, postgres exits with message:
>     FATAL:  terminating connection due to administrator command

Something is sending SIGTERM signals to your backend processes (or, if
the postmaster stops too, SIGINT to the postmaster).  Find out what's
doing that and make it stop ;-).  I'd bet on "ulimit" or some other
resource-limiting feature.

            regards, tom lane