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

Download the Tutorial


For detailed information about installing Advanced Server, refer to the EDB Postgres Advanced Server Installation Guide.