You may need to increase the maximum connections if you receive an error message similar to the following:

  • Failed to connect to back-end database "TranDb"
    FATAL: remaining connection slots are reserved for non-replication superuser 
  • (0) SQL Error! SQLSTATE = 53300 Native err = 210 msg = FATAL: remaining connection slots are reserved for non-replication superuser connections 
  • (1) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed 
  • Details: 
    Unable to connect to database using connection string:

In order to increase your maximum connections in PostgreSQL, set the max_connections = 200 in the file C:\Program Files (x86)\PostgreSQL\9.0\data\postgresql.conf if you are on windows.

Last updated: