Posted On: Aug 9, 2019
Publishing these logs to CloudWatch Logs allows you to maintain continuous visibility into Aurora PostgreSQL system logs for your Aurora PostgreSQL databases. For example, you can set up Amazon CloudWatch Alarms to notify you on frequent restarts which are recorded in the Aurora PostgreSQL system log. Similarly, alarms for events recorded in Aurora PostgreSQL logs can be created to alert on unwanted changes made to your databases. You may also enable logging of slow queries and create alarms to monitor them in the Aurora PostgreSQL logs and enable timely detection of long-running queries.
CloudWatch Logs provide a durable archive destination for your database logs. You can specify a retention period to indicate how long you want CloudWatch to retain your logs. Additionally, with CloudWatch Logs, you can perform ad hoc searches across multiple logs. This capability is particularly useful for troubleshooting, audits, and log analysis. You can also export logs from CloudWatch to Amazon S3.
Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better throughput than the typical PostgreSQL database, together with increased scalability, durability, and security. To learn more about Amazon Aurora with PostgreSQL compatibility, please visit our product page.