PostgreSQL check

reference australia Updated Sep 29, 2026 1 min read postgresql-check.md

Credential and permission requirements for the PostgreSQL checks that monitor database size, statistics, connections, and locks.

PostgreSQL database account

The database user configured in the ServiceNow credential must meet the following requirements.

Required for every check in this group: the account must be allowed to authenticate and connect to the specific database named in --database. It needs CONNECT privilege on that database, and pg_hba.conf on the server must permit login from the agent host for that user and database combination.
Required only for postgresql.check-connections and postgresql.metric-active-connections: the pg_monitor role on Postgres 10+, or superuser. Both checks query pg_stat_activity across all databases and sessions.

Configuration Prerequisites:

The Postgres TCP endpoint must be reachable from the agent host.

pg_hba.conf must let the agent host's source IP to authenticate for this user and database.
The connection sslmode=disable is hard-coded. If the server enforces SSL/TLS only through hostssl entries, the check fails with an SSL-negotiation error that can look like an authentication failure.
Confirm pg_monitor is granted if you're using connection or stats metrics.

Parent Topic:Agent Client Collector checks – credential and permission requirements

36 lines · 2.2 KB Wrap lines

---
title: PostgreSQL check
description: Credential and permission requirements for the PostgreSQL checks that monitor database size, statistics, connections, and locks.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/it-operations-management/agent-client-collector/postgresql-check.html
release: australia
product: Agent Client Collector
classification: agent-client-collector
topic_type: reference
last_updated: "2026-09-29"
reading_time_minutes: 1
breadcrumb: [Agent Client Collector checks – credential and permission requirements, ACC-M reference, Agent Client Collector reference, Agent Client Collector, IT Operations Management]
---

# PostgreSQL check

Credential and permission requirements for the PostgreSQL checks that monitor database size, statistics, connections, and locks.

## PostgreSQL database account

The database user configured in the ServiceNow credential must meet the following requirements.

- Required for every check in this group: the account must be allowed to authenticate and connect to the specific database named in `--database`. It needs `CONNECT` privilege on that database, and `pg_hba.conf` on the server must permit login from the agent host for that user and database combination.
- Required only for `postgresql.check-connections` and `postgresql.metric-active-connections`: the `pg_monitor` role on `Postgres 10+`, or superuser. Both checks query `pg_stat_activity` across all databases and sessions.

Configuration Prerequisites:

The Postgres TCP endpoint must be reachable from the agent host.

- `pg_hba.conf` must let the agent host's source IP to authenticate for this user and database.
- The connection `sslmode=disable` is hard-coded. If the server enforces SSL/TLS only through `hostssl` entries, the check fails with an SSL-negotiation error that can look like an authentication failure.
- Confirm `pg_monitor` is granted if you're using connection or stats metrics.

**Parent Topic:**[Agent Client Collector checks – credential and permission requirements](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-operations-management/agent-client-collector/acc-monitoring-checks-credential-and-permission-requirements.md)