Postgres Advanced Server allows database and security administrators, auditors, and operators to track and analyze database activities using audit logs which are a key component to
general data governance, security, risk management, trouble shooting and pre-production testing. This tutorial documents how to create and review an audit log. Audit logs can be configured to include:
- When a role establishes a connection to an Advanced Server database.
- When a role disconnects from an Advanced Server database.
- When database objects are created, modified or deleted from a database.
- When queries are performed against the database.
- When failed authentication attempts occur.
- When failed attempts to perform unauthorized activities occur
- Capturing middle tier data tied more closely to actual user identification and location
For detailed information about installing Advanced Server, refer to the EDB Postgres Advanced Server Installation Guide.