Automate interval partitioning maintenance and monitoring in Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL – Part 2
Database Blog
This article demonstrates how to monitor and send alerts for interval partitioning maintenance jobs in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using PostgreSQL extensions, AWS Lambda, and Amazon Simple Notification Service (SNS).
Specifically, the article covers:
- Solution overview - Using pg_cron, aws_lambda, Lambda, and SNS to monitor partitioning jobs and send alerts on failure
- Prerequisites and setup steps for aws_lambda, PostgreSQL procedures, AWS SAM deployment, and configuring monitoring jobs
- Details of AWS services deployed using SAM (IAM role, Lambda function, VPC endpoints, security group, SNS topic)
- Testing the solution using a CloudFormation template
- Cleanup steps to remove deployed resources
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Apr 1
2024
2024
Replicate data between partitioned and non-partitioned tables using trigger functions in Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL
Oct 29
2025
2025
AI-powered tuning tools for Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL databases: PI Reporter
Mar 18
2026
2026
Automated parameter and option group change monitoring in Amazon RDS and Amazon Aurora
Jan 27
2026
2026
Strategies for upgrading Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL from version 13
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.