Aurora PostgreSQL database log files
You can monitor the following types of Aurora PostgreSQL log files:
-
PostgreSQL log
-
Instance log
-
IAM database authentication error log
Aurora PostgreSQL logs database activities to the default PostgreSQL log file. For
an on-premises PostgreSQL DB instance, these messages are stored locally in
log/postgresql.log
. For an Aurora PostgreSQL DB
cluster,
the log file is
available on the Aurora cluster. These logs are also accessible via the Amazon Web Services Management Console,
where you can view or download them. The default logging level captures login failures, fatal
server errors, deadlocks, and query failures.
For more information about how you can view, download, and
watch file-based database logs, see Monitoring Amazon Aurora log files.
To learn more about PostgreSQL logs, see Working with
Amazon RDS and Aurora PostgreSQL logs: Part 1
In addition to the standard PostgreSQL logs discussed in this topic,
Aurora PostgreSQL
also supports the PostgreSQL Audit extension (pgAudit
). Most regulated industries and government
agencies need to maintain an audit log or audit trail of changes made to data to comply with legal requirements.
For information about installing and using pgAudit, see Using pgAudit to log database activity.
Aurora creates a separate log file for DB instances that have auto-pause enabled. This instance.log file records any reasons why these DB instances couldn't be paused when expected. For more information on instance log file behavior and Aurora auto-pause capability, see Monitoring Aurora Serverless v2 pause and resume activity.
Topics