- 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
- (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
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.