-->
  • Recent Articles

    PostgreSQL FATAL: terminating connection due to administrator command

    What is PostgreSQL?

    PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. More Information about PostgreSQL can be found at the PostgreSQL official Documentation.  On 08th November 2018 PostgreSQL 11.1, 10.6, 9.6.11, 9.5.15, 9.4.20, and 9.3.25 Released! 







    Error:

    FATAL: terminating connection due to administrator command


    Cause:

    If user stop postgresql server with "service postgresql stop" or if any SIGINT has been called on the postgresql PID then this error will occur.



    Resolution:


    You need to check if there are any processes that are abtuputly killing the PostgreSQL sessions. 

    1 comment:

    1. In my case, I run postgres container as systemd service, I found out that the unit service is referring to an old invalid container PID. After I regenerate the systemd service file and run it, it was run smooth without hiccups.

      Hope this help.

      ReplyDelete