PostgreSQL configuration

This guide describes how to run the PostgreSQL configuration program that is included with Monitor Server. Use it after installing PostgreSQL to set recommended values for your environment.

Before you start

  • Know how many CPU cores and RAM are available, as well as the storage type on the PostgreSQL server.

  • Know how many production databases you will run.

  • Know how many Monitor user licenses you have (used to size connections).

  • Ensure PostgreSQL is installed and the service is running.

Run the configuration

  1. Open Monitor.PostgresConfigurationManager.exe, it can be found in the Monitor Server folder.

  2. Or open it from inside Monitor. It can be found in the Database Administration procedure under the PostgreSQL configuration tab.

  3. Enter values for CPU, memory, storage type, database count, and connections (see the rules below).

  4. Generate and save the configuration.

  5. Restart the PostgreSQL service to ensure the new settings take effect.

  6. Verify that Monitor can connect and that performance is acceptable.

Recommended values

  • CPU and memory (same server as Monitor ERP): If PostgreSQL runs on the same server as Monitor ERP, enter half of the available CPU cores and half of the available memory.

  • If PostgreSQL runs on a dedicated database server (separate from Monitor ERP), size CPU and memory according to your database server capacity and operational requirements.

  • Database count: Set to 1.5 × the number of production databases.

  • Connections: Set to the number of Monitor licenses, but never lower than 100.

Input Example
Server has 16 CPU cores and 64 GB RAM, and PostgreSQL runs on the same server as Monitor ERP CPU = 8, Memory = 32 GB
Production databases = 10 Database count = 15
Licenses = 60 Connections = 100 (minimum