Prepare to run the PostgreSQL collector

Release version: Australia

Updated March 12, 2026

1 minute to read

Create a PostgreSQL user and configure permissions before running the collector.

Before you begin

Role required: admin

Procedure

Create a new role.
```
CREATE ROLE ddw_role;
```

Grant metadata harvesting permissions to the role.

GRANT SELECT ON ALL TABLES IN SCHEMA information_schema TO ddw_role;
GRANT SELECT ON ALL TABLES IN SCHEMA "<schemaName>" TO ddw_role;
GRANT SELECT ON TABLE pg_namespace TO ddw_role;
GRANT SELECT ON TABLE pg_class TO ddw_role;
GRANT SELECT ON TABLE pg_description TO ddw_role;
GRANT SELECT ON TABLE pg_attribute TO ddw_role;
GRANT SELECT ON TABLE pg_type TO ddw_role;
GRANT SELECT ON TABLE pg_attrdef TO ddw_role;
GRANT SELECT ON TABLE pg_index TO ddw_role;
GRANT SELECT ON TABLE pg_proc TO ddw_role;
GRANT SELECT ON TABLE pg_database TO ddw_role;
GRANT SELECT ON TABLE pg_matviews TO ddw_role;

Replace <schemaName> with your schema name.

Optional: Grant permissions for column statistics harvesting.
Run these commands for each database and schema you want to collect statistics from:
```
GRANT USAGE ON SCHEMA "<schemaName>" TO ddw_role;
 GRANT SELECT ON ALL TABLES IN SCHEMA "<schemaName>" TO ddw_role;
```
Replace <schemaName> with your schema name.
Create a user and assign the role.
```
CREATE USER ddw_user PASSWORD '<password>';
GRANT ddw_role TO ddw_user;
```
Replace <password> with a secure password.
Optional: Configure IAM authentication.

See the AWS IAM authentication documentation for setup instructions.