14.0 Configuring PostgreSQL

Each Primary Server on PostgreSQL can consume up to 500 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 external database, the postgresql.conf file is available at the following location:

  • On Windows: <install_directory>\PostgreSQL\<version>\data

  • On Linux: /var/lib/pgsql/<version>/data

Use the following formula to calculate the property values.

max_connections = Number of primary severs * 500

max_prepared_transactions = Number of primary severs * 500

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

To start the PostgreSQL service:

  • On Windows: To start the service, perform the following:

    1. Press Windows + R keys.

    2. Type services.msc.

    3. Search for the PostgreSQL service based on the installed version.

    4. Click Start the service.

  • On Linux: To start the service, run the systemctl start postgresql.service command.

For more information, see PostgreSQL Tuning and Maintenance in the ZENworks Best Practices Guide.