Re: postgresql 9.4 restart

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

Re: postgresql 9.4 restart

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

Re: postgresql 9.4 restart

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

Re: postgresql 9.4 restart

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

Re: postgresql 9.4 restart

:17 PM To: Julie Nishimura Cc: pgsql-general@lists.postgresql.org; pgsql-general Subject: Re: postgresql 9.4 restart On 5/8/19 2:01 PM, Julie Nishimura wrote: > Adrian, thanks for your reply! > > > > PostgreSQL 9.4.21 on x86_64-pc-linux-gnu (Ubuntu 9.4.21-1.pgdg16.04+1), > compiled

Re: postgresql 9.4 restart

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

Re: postgresql 9.4 restart

,"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

Re: postgresql 9.4 restart

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

postgresql 9.4 restart

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 exception is org.postgresql.util.PSQLException: FATAL: