Connections closing due to "terminating connection due to administrator command"

From: Herouth Maoz <herouth(at)unicell(dot)co(dot)il>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Connections closing due to "terminating connection due to administrator command"
Date: 2015-07-27 09:16:54
Message-ID: BA2AEDD6-1B9E-4E3D-BD71-B6ABF2D0353A@unicell.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everybody.

In the past week, it has happened to us twice already that we got an exception from our Java application, due to PostgreSQL "terminating connection due to administrator command”.

The problem is that I’m the administrator, and I issued no such command.

On the first opportunity that it happened, the PostgreSQL server actually seemed to have spontaneously shut itself down and restarted:

2015-07-21 15:37:59 IDT LOG: received fast shutdown request
2015-07-21 15:37:59 IDT LOG: aborting any active transactions
2015-07-21 15:37:59 IDT FATAL: terminating connection due to administrator command

2015-07-21 15:38:01 IDT LOG: shutting down
2015-07-21 15:38:02 IDT LOG: database system is shut down
2015-07-21 15:40:16 IDT LOG: database system was shut down at 2015-07-21 15:38:02 IDT

On today’s occasion, the server seems to be continuing as usual, and there is nothing whatsoever in the log.

So my questions are:

* Given that I did not terminate any backend connection interactively, why did I get a "terminating connection due to administrator command” message? Is there any situation where this message is issued without the administrator being involved?
* What could have caused the shutdown on the 21st of July? Again, I did not issue a shutdown request for that server, and the machine didn’t restart.

The server is running PostgreSQL 9.1.16.

Thank you,
Herouth

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Withers 2015-07-27 10:19:49 Re: pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away
Previous Message Amit Bondwal 2015-07-27 07:48:53 Postgres SSL connection without client certificates.