EDB audit logging v15

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 contain all of the relevant information. You can configure the audit logs 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