Article ID: 112993, created on Dec 12, 2011, last review on May 9, 2014

  • Applies to:
  • Operations Automation 5.x

Symptoms

While trying to log in to POA Control Panel, the login screen reloads and the following error is displayed:[unixODBC]FATAL: connection limit exceeded for non-superusers while Connecting

Cause

POA is unable to establish a new connection to its database, as the number of concurrent connections has reached the limit defined in the database configuration.

Resolution

Alter the database configuration file and increase the maximum number of simultaneous connections. Edit the file /var/lib/pgsql/data/postgresql.conf and set the max_connections value to "256" as shown below:max_connections = 256Restart the POA database to apply the changes:# /etc/init.d/postgresql restart

2554725ed606193dd9bbce21365bed4e 5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF