Using pgaudit in Managed Service for PostgreSQL

The pgaudit extension provides additional logging tools and enhanced auditing capabilities.

Installing the pgaudit extension in a PostgreSQL clusterInstalling the pgaudit extension in a PostgreSQL cluster

1. Load the pgaudit shared library into your cluster.
2. Enable the pgaudit extension in your database.
3. For users whose actions should be audited, specify the required Pg audit log values. For more information, see Changing user settings.

Audit logs will be included in the cluster logs.

Learn more about the pgaudit extension in this official guide.