pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPG_CRON in AWS RDS PostgreSQL
3+ messages / 3 participants
[nested] [flat]
* PG_CRON in AWS RDS PostgreSQL
@ 2021-04-07 11:16 Prashant Kulkarni <ppk10.prashant@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Prashant Kulkarni @ 2021-04-07 11:16 UTC (permalink / raw)
To: pgsql-admin
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!!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PG_CRON in AWS RDS PostgreSQL
@ 2021-04-07 11:23 John Scalia <jayknowsunix@gmail.com>
parent: Prashant Kulkarni <ppk10.prashant@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: John Scalia @ 2021-04-07 11:23 UTC (permalink / raw)
To: Prashant Kulkarni <ppk10.prashant@gmail.com>; +Cc: pgsql-admin
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!!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PG_CRON in AWS RDS PostgreSQL
@ 2021-04-07 11:41 Jayson Hreczuck <jayson.hreczuck@studentuniverse.com>
parent: John Scalia <jayknowsunix@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jayson Hreczuck @ 2021-04-07 11:41 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: Prashant Kulkarni <ppk10.prashant@gmail.com>; pgsql-admin
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!!
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-04-07 11:41 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-04-07 11:16 PG_CRON in AWS RDS PostgreSQL Prashant Kulkarni <ppk10.prashant@gmail.com>
2021-04-07 11:23 ` John Scalia <jayknowsunix@gmail.com>
2021-04-07 11:41 ` Jayson Hreczuck <jayson.hreczuck@studentuniverse.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox