Postgres Pro
Downloads
Home   >   mailing lists

Re: PG_CRON in AWS RDS PostgreSQL - Mailing list pgsql-admin

From Jayson Hreczuck
Subject Re: PG_CRON in AWS RDS PostgreSQL
Date
Msg-id CAHg7=h4UE8pw94z0TVKOjHvv1us23nTFPpjZbpfF+78_FdvBLQ@mail.gmail.com
Whole thread Raw
In response to Re: PG_CRON in AWS RDS PostgreSQL  (John Scalia <jayknowsunix@gmail.com>)
List pgsql-admin
Tree view
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.
—
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!!

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: PG_CRON in AWS RDS PostgreSQL
Next
From: Victor Sudakov
Date:
Subject: "fsync = off" in recovery