Posted On: Dec 10, 2018
Publishing these logs to CloudWatch Logs allows you to maintain continuous visibility into PostgreSQL system logs, and upgrade logs for your PostgreSQL databases. For example, you can set up Amazon CloudWatch Alarms to notify you on frequent restarts which are recorded in the PostgreSQL system log. Similarly, alarms for events recorded in 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 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.
Refer to the RDS for PostgreSQL documentation for more information. To start publishing logs from RDS for PostgresQL databases to CloudWatch Logs, visit the AWS RDS Management Console or download the latest AWS SDK or CLI.
Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. See Amazon RDS for PostgreSQL Pricing for regional availability.