PostgreSQL fatal error: a reserved connection location reserved for Superuser who performs non-replication requests

Recent monitoring System database monitoring is always delayed, check the log error:

 --08- - Ten: -: +,534 ERROR Traceback(most recent):  File "oracle_mon.py", line306,inch< module>Update_status (IP,' Stop ', timer.end_date)File "oracle_mon.py", line285,inchUpdate_status Pg.db.update ("Oracle_mon", Where=where, Status=status, Stat_date=status_date)File "/usr/lib/python2.7/site-packages/web/db.py", line881,inchUpdate db_cursor = Self. _db_cursor ()File "/usr/lib/python2.7/site-packages/web/db.py", line566,inch_db_cursorreturn  Self. Ctx.db.cursor ()File "/usr/lib/python2.7/site-packages/web/db.py", line507,inch_getctx Self. _load_context ( Self. _ctx)File "/usr/lib/python2.7/site-packages/web/db.py", line516,inch_load_context ctx.db = Self. _connect_with_pooling ( Self. Keywords)File "/usr/lib/python2.7/site-packages/web/db.py", line970,inch_connect_with_pooling conn =DB. _connect_with_pooling ( Self, keywords)File "/usr/lib/python2.7/site-packages/web/db.py", line563,inch_connect_with_poolingreturn  Self. _pooleddb.connection ()File "/usr/lib/python2.7/site-packages/dbutils-1.1-py2.7.egg/dbutils/pooleddb.py", line331,inchConnection con = Self. Steady_connection ()File "/usr/lib/python2.7/site-packages/dbutils-1.1-py2.7.egg/dbutils/pooleddb.py", line279,inchSteady_connection * Self. _args, * * Self. _kwargs)File "/usr/lib/python2.7/site-packages/dbutils-1.1-py2.7.egg/dbutils/steadydb.py", line134,inchConnect failures, Ping, closeable, *args, **kwargs)File "/usr/lib/python2.7/site-packages/dbutils-1.1-py2.7.egg/dbutils/steadydb.py", line186,inch__init__     Self. _store ( Self. _create ())File "/usr/lib/python2.7/site-packages/dbutils-1.1-py2.7.egg/dbutils/steadydb.py", line the,inch_create con = Self. _creator (* Self. _args, * * Self. _kwargs)File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line179,inchConnect Connection_factory=connection_factory, Async=async)Operationalerror:Fatal error:Reserved connection locations are reserved for super users that perform non-replication requests

The number of active connections found in the database is around 90, while the default maximum number of connections for PG is MAX_CONNECTION=100, which is suspected to be an error in the number of database connections.

The fact is that the old database max_connection=200, and does not use the default 100.

Workaround: Modify the default maximum number of connections in the configuration file (postgresql.conf) max_connection=200, and restart the database.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

PostgreSQL fatal error: a reserved connection location reserved for Superuser who performs non-replication requests