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(dot)klaver(at)aklaver(dot)com