If an Enterprise System Manager (EM) installation is using the Postgres database with 500 or more servers, you could see the following error in the log file: “OperationalError: FATAL: sorry, too many clients already.”
To increase the number of connections allowed, complete the following steps:
<br>
- Stop all ESM services (ExacqVision Enterprise Manager Importer, ExacqVision Enterprise Manager Datarolloff, ExacqVision Enterprise Manager Sendemail, and ExacqVision Enterprise Manager WebService).
- Open the Postgre configuration file:
Linux: /usr/local/exacq/esm/PostgreSQL/9.2/data/postgresql.conf
Windows: C:\Program Files\exacqVision\EnterpriseManager\PostgreSQL\10.17\data\ postgresql.conf - Find the line that contains “max_connections,” change the value to 500, and save the file.
NOTE: Each additional connection greater than 100 uses 400 bytes of memory. - Restart the Postgres service.
- Restart the ESM services.
<br>
Increasing-the-Number-of-Connections-Allowed-in-ESM.pdf