Posted On: Jul 22, 2021

Amazon Aurora PostgreSQL-Compatible Edition adds support for the pg_cron extension in AWS GovCloud (US) regions. 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 AWS open source contribution that adds an audit table so that you can query the outcome of each scheduled job.

You can view a list of all PostgreSQL extensions supported by database version on Amazon Aurora on the AWS User Guide. With this regional expansion, pg_cron is available in all commercial regions. For full feature parity list, head to our feature parity page, and to see all the regions that support Amazon Aurora head to our region page.

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 performance than the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Amazon Aurora product page. To get started with Amazon Aurora, take a look at our getting started page.

Don't see an extension you'd like to use? Let us know through the AWS Forum, through AWS Enterprise support.