Thread: PG_CRON in AWS RDS PostgreSQL
Hi Team,
Please anybody can share the details regarding PG_CRON in AWS RDS.
1.How to schedule jobs using PG_CRON in AWS RDS instances.
2.Can we execute any SQL script on schedule basis using pg_cron in RDS?
Thank you!!
I recently looked into this for one of my development teams. Pg_cron requires that you’re running version 12.x or higher. Unfortunately, my team is still running v.11.9 so we couldn’t use pg_cron.
—
Jay
Sent from my iPad
On Apr 7, 2021, at 7:17 AM, Prashant Kulkarni <ppk10.prashant@gmail.com> wrote:
Hi Team,Please anybody can share the details regarding PG_CRON in AWS RDS.1.How to schedule jobs using PG_CRON in AWS RDS instances.2.Can we execute any SQL script on schedule basis using pg_cron in RDS?Thank you!!
We use pgagent, which has support up to the most recent version of postgres. I've also got it working on my AWS E2C instance, but not sure if it's available on Amazons out of the box databases (RDS).
On Wed, Apr 7, 2021, 7:23 AM John Scalia <jayknowsunix@gmail.com> wrote:
I recently looked into this for one of my development teams. Pg_cron requires that you’re running version 12.x or higher. Unfortunately, my team is still running v.11.9 so we couldn’t use pg_cron.—JaySent from my iPadOn Apr 7, 2021, at 7:17 AM, Prashant Kulkarni <ppk10.prashant@gmail.com> wrote:Hi Team,Please anybody can share the details regarding PG_CRON in AWS RDS.1.How to schedule jobs using PG_CRON in AWS RDS instances.2.Can we execute any SQL script on schedule basis using pg_cron in RDS?Thank you!!