If you are running Linux (please ALWAYS give the O/S ), then this could have been caused by the sys admin doing a system shutdown.
Otherwise, anyone that can sudo to postgres could also have potentially issued a pg_ctl stop. I strongly suggest you review the _system_ logs for a possible hint as to whom could have done that. Also, consider adding the user name into the log prefix ( # %u = user name ) On Mon, Jul 27, 2015 at 9:39 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 07/27/2015 02:16 AM, Herouth Maoz wrote: > >> 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? >> > > This error message comes from intervention by a program external to > Postgres: > > http://www.postgresql.org/message-id/4564.1284559...@sss.pgh.pa.us > > So what OS and version are you running? > > What does the Java app do besides accessing the database? > > Do you have other programs that monitor/control the database? > > > * 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. >> > > Is there anything in logs before the above that might give a clue? > > >> >> The server is running PostgreSQL 9.1.16. >> >> Thank you, >> Herouth >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
