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 exception is
> org.postgresql.util.PSQLException: FATAL: terminating connection due to
> administrator command”,

Distro and version?

Well it originated in Java code if that helps?

Anything in the Postgres logs just prior to 'FATAL: terminating 
connection ...' that might be relevant?

Do the system logs showing anything relevant e.g. the OOM killer 
stopping Postgres?



> 
> Then I could see that postgresql got restarted, based on the output of 
> "select pg_postmaster_start_time()"
> 
> We are running postgresql on
> Linux xxx-generic #83-Ubuntu SMP Wed Jan 18 14:10:15 UTC 2017 x86_64 
> x86_64 x86_64 GNU/Linux
> 
> How I can find out what cause the restart? Any ideas are welcome. Thanks!
> 
> -Julie N
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com