Using pgaudit in Managed Service for PostgreSQL

The pgaudit extension provides additional logging tools and enhances the audit features.

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

1. Enable the shared library named pgaudit for your cluster.
2. Add pgaudit to the database.
3. For users whose actions should be logged to an audit log, specify the required Pg audit log setting values. For more information, see Changing user settings.

Audit logs will be available when viewing cluster logs.

To learn more about the pgaudit extension, see the official documentation.