PostgreSQL

Inventory database roles and login users.

Source connector

Source connector — pulls identity and access data from PostgreSQL into ComplianceScout where it is scored against your compliance frameworks and violation rules.

What ComplianceScout collects

After a successful sync, the following data is available in your ComplianceScout dashboard for violation detection and reporting.

All PostgreSQL roles (users and groups) with login privilege status
Role membership and inheritance chains
Superuser and CREATEDB/CREATEROLE privilege flags per role
Connection limit and expiry settings per role

Required credentials

These fields are collected when you add the connector in the ComplianceScout dashboard. Secrets are encrypted at rest using AES-256-GCM and are never logged.

Field	Type	Required	Notes
Host	Text	Required	—
Port	Text	Optional	Default 5432
Database	Text	Required	—
User	Text	Required	—
Password	Secret	Required	—

How to set up this connector

Follow these steps to gather the credentials above and connect PostgreSQL to ComplianceScout.

Create a read-only PostgreSQL user: CREATE USER compliancescout WITH PASSWORD '...';
Grant the necessary privileges: GRANT pg_read_all_settings TO compliancescout; GRANT SELECT ON pg_roles, pg_auth_members TO compliancescout;
Ensure the ComplianceScout IP is allowed in your pg_hba.conf and firewall rules.
In ComplianceScout, go to Data & Secrets → Integrations → Add Connector → PostgreSQL, enter the connection details, and click Test and Save.

Ready to connect PostgreSQL?

Start a free trial — your tenant is provisioned instantly and you can wire up this integration from the connectors page.

Start a free trial Add connector →