Skip to end of metadata
Go to start of metadata

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 
    connections 
     
  • (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:
    UID=jitterbit;PWD=<REMOVED>;SERVER=127.0.0.1;DRIVER={PostgreSQL ODBC 
    Driver(UNICODE)};DATABASE=TranDb;Port=5432;! 

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.

Related Topics

Last updated:  May 13, 2018