Sumologic

PostgreSQL

Specify the port, database (which you wish to monitor), username and password in the data.json on your server. It is recommended to create a monitoring user as:

  • create user archagent with password 'archagent';
  • grant SELECT ON pg_stat_database to archagent;
  • Make entry in pg_hba.conf

In the databases field, enter the names of the databases you want to monitor. Please note that at least one database name needs to be provided. The default data.json entry for PostgreSQL is as follows.

"postgres": {
        "port": 5432,
        "databases": [],
        "username": "archagent",
        "password": "archagent"
    },

Having updated data.json on your server (no need to restart archagent), enable this plugin from the server's rule config page. Set thresholds for metrics that you care about and want to be alerted on. Enabling a plugin.

More details on the individual metrics can be found here

results matching ""

    No results matching ""