Using EDB audit logging v16
EDB Postgres Advanced Server allows database and security administrators, auditors, and operators to track and analyze database activities using EDB audit logging. EDB audit logging generates audit log files, which can be configured to record information such as:
- When a role establishes a connection to an EDB Postgres Advanced Server database
- The database objects a role creates, modifies, or deletes when connected to EDB Postgres Advanced Server
- When any failed authentication attempts occur
The parameters specified in the configuration files postgresql.conf
or postgresql.auto.conf
control the information included in the audit logs.
audit_logging_configuration_parameters selecting_sql_statements_to_audit enabling_audit_logging audit_log_file using_error_codes_to_filter_audit_logs using_command_tags_to_filter_audit_logs redacting_passwords_from_audit_logs audit_log_archiving object_auditing
Selecting SQL statements to audit
How to use the edb_audit_statement to include comma-separated values to control the SQL statements to audit
Enabling audit logging
How to configure EDB Postgres Advanced Server to log the items you want to audit
Using error codes to filter audit logs
Describes how to filter the audit logs based on specific error codes
Using command tags to filter audit logs
Describes how to use command tags to find log file entries related to a SQL command
Redacting passwords in audit logs
Describes how to redact stored passwords in the audit log file
Archiving audit logs
Describes how to use the Audit Archiver to manage audit log files
Auditing objects
Describes how to selectively audit objects for specific DML statements