In this hands-on lab, students will enable audit logging using the `pgaudit` extension. They will then review the audit log created.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Install the `pgaudit` Extension.
- Install the
pgaudit
extension. This extension enables detailed session, and object audit logging, via the standard logging facility.
- Install the
- Configure the Extension
- Configure the pgaudit extension, to log all DDL, ROLE, READ and WRITE statements.
- Test the Extension
- Generate some WRITE activity on the server and confirm the log is generated as expected.