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

From: Herouth Maoz <herouth(at)unicell(dot)co(dot)il>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Connections closing due to "terminating connection due to administrator command"
Date: 2015-07-27 15:07:40
Message-ID: 3ADC2F62-F130-4881-825D-8044319704EE@unicell.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On 27 ביולי 2015, at 16:55, Melvin Davidson <melvin6925(at)gmail(dot)com> wrote:
>
> 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.

Yes, sorry about that, as I previously answered Adrian Klaver, the OS is Debian Gnu/Linux 7.

But I did mention that the machine has not been restarted (it currently has a 45 day uptime). And the sysadmin says he didn’t do anything on that machine on that day.

>
> Otherwise, anyone that can sudo to postgres could also have potentially issued a
> pg_ctl stop.

The only people with access to that machine are myself (through ssh to the postgres account) and the sysadmin. That machine is basically a dedicated database server.

>
> 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 )

I’ve asked the sysadmin to look at the system logs. I’ll consider the user name suggestion. Thank you.

Herouth

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2015-07-27 15:20:49 Re: Connections closing due to "terminating connection due to administrator command"
Previous Message Kevin Grittner 2015-07-27 15:06:54 Re: Splitting a string containing a numeric value in to three parts