9.0 Configuring PostgreSQL

Each Primary Server on PostgreSQL can consume up to 300 database connections. If you want to add more than one Primary Server, you should change the property values in the postgresql.conf file.

For the embedded database, the postgresql.conf file is available at the following location:

  • On Windows: ZENworks\database\pgsql\data\postgresql.conf

  • On Linux: zenworks/database/pgsql/data/postgresql.conf

Use the following formula to calculate the property values.

max_connections = Number of primary severs * 300

max_prepared_transactions = Number of primary severs * 300

After changing the property values in postgresql.conf, restart the ZENworks and PostgreSQL service.