Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Panel
borderColor#00B886
titleColor#FFFFFF
titleBGColor#00B886
titleRelated Topics
Content by Label
showLabelsfalse
max1000
showSpacefalse
sorttitle
cqllabel in ("local-agent-overview","install-overview","sys-req-overview") and space = "DOC"

HideElements
metastrue

Last updated: 

Lastmodifieddate