Thanks for your help, Adrian!
From: Adrian Klaver
Sent: Thursday, May 9, 2019 9:41 AM
To: Julie Nishimura
Cc: pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: postgresql 9.4 restart
On 5/9/19 8:10 AM, Julie Nishimura wrote:
> Etc/UTC
Well th
On 5/9/19 8:10 AM, Julie Nishimura wrote:
Etc/UTC
Well there goes that theory:(
Not sure where to go from here, other then monitor the logs and
connections more aggressively.
--
Adrian Klaver
adrian.kla...@aklaver.com
Etc/UTC
From: Adrian Klaver
Sent: Thursday, May 9, 2019 7:51 AM
To: Julie Nishimura
Cc: pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: postgresql 9.4 restart
On 5/8/19 4:35 PM, Julie Nishimura wrote:
> Thanks again for your help.
&g
ecause
maybe it was close to max connections - just a guess). What do you think?
-Julie N
*From:* Adrian Klaver
*Sent:* Wednesday, May 8, 2019 2:17 PM
*To:* Julie Nishimura
*Cc:* pgsql-general@lists.postgresql.org; pgsql-general
*Subjec
cd0cc20.2170,6,"idle",2019-05-07
> 00:06:56 UTC,227/0,0,FATAL,57P01,"terminating connection due to
> administrator command",,,,,""
> 2019-05-07 00:08:28.060
> UTC,"hitwise","hitwise_uk_stg",8558,"10.200.193.58:49246",5cd0cc20.21
quot;,2019-05-07
00:06:56 UTC,,0,LOG,0,"disconnection: session time: 0:01:31.339
user=hitwise database=hitwise_uk_stg host=10.200.193.58
port=49246",""
2019-05-07 00:08:28.060
UTC,"hitwise","hitwise_au_stg",8578,"10.200.250.49:31100",5c
,"terminating connection due to administrator
command",""
2019-05-07 00:08:28.060
UTC,"hitwise","hitwise_uk_stg",8558,"10.200.193.58:49246",5cd0cc20.216e,7,"idle",2019-05-07
00:06:56 UTC,,0,LOG,0,"disconnection: session time
On 5/8/19 11:00 AM, Julie Nishimura wrote:
Hello,
Our staging 9.4 postgresql has been running couple of weeks with no
problem, but yesterday we saw this error from one of our services that
connects to the staging DBs:
FATAL: terminating connection due to
administrator command; nested exceptio
