v1.4.3

Note

Binaries are code-wise the same, the only change from 1.4.2 is the README updates.

Multiple Database Backends

PgRoleCheck supports monitoring multiple PostgreSQL instances. Specify each instance in the pgrolecheck.conf under separate headers, prefixed with database_, e.g., [database_primary], [database_replica], etc., with unique connection details for each.

Configuration Options

Database Configuration

Configure each database by prefixing with database_ and providing connection details:

[database_primary]
dbname=primarydb
user=dbuser1
...

[database_replica]
dbname=replicadb
user=dbuser2
...

Server Configuration

output_format: Sets the response format. Options are json, plain, or csv. Default is json.

Security Configuration

Under the [security] section, specify access control options:

ip_whitelist: Comma-separated list of IP addresses allowed access. Leave blank to permit all.
auth_token: Secret token for API authentication, required in request headers.

[security]
ip_whitelist=192.168.1.100,127.0.0.0/8
auth_token=mysecrettoken