Article ID: 128523, created on Mar 8, 2016, last review on Mar 8, 2016

  • Applies to:
  • Business Automation

Symptoms

Connection to BA is slow, sometimes billing is not responsive, lots of statement timeout errors. Attempt to enter the database result in the error message:

[root@bm ~]# psql -h database.ip -U pba
psql: FATAL:  remaining connection slots are reserved for non-replication superuser connections

Cause, resolution

PosrgreSQL is overloaded.

  1. Check the number of maximum connections to the database - max_connections in /var/lib/pgsql/data/postgresql.conf.
  2. Check the number of current connections, e.g. by listing the processes (as select from pg_stat_activity is not possible due to impossibility to enter the database).
  3. Check what used so many connections, verify if they are really required or there is some way to use less connections.
  4. Resolve the situation either by restricting access to the database to some scripts or whatever uses it or increase the number of max_connections.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF