Posted On: Jul 14, 2021
Starting today, Amazon Aurora PostgreSQL supports the pgcron extension.
pg_cron allows you to use cron syntax to schedule PostgreSQL commands directly within your database. You can use pg_cron to schedule tasks such as periodically rolling up data for analytic reports, refreshing materialized views, and scheduling vacuum jobs to reclaim storage. pg_cron includes an Amazon Web Services open source contribution that adds an audit table so that you can query the outcome of each scheduled job.
Please review the Aurora documentation to learn more. You can view a list of all PostgreSQL extensions supported on RDS on the Amazon Web Services User Guide.
Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. To get started with Amazon Aurora PostgreSQL, take a look at our getting started page.