Re: PG_CRON in AWS RDS PostgreSQL

Поиск
Список
Период
Сортировка
От Jayson Hreczuck
Тема Re: PG_CRON in AWS RDS PostgreSQL
Дата
Msg-id CAHg7=h4UE8pw94z0TVKOjHvv1us23nTFPpjZbpfF+78_FdvBLQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PG_CRON in AWS RDS PostgreSQL  (John Scalia <jayknowsunix@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!!

В списке pgsql-admin по дате отправления:

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: PG_CRON in AWS RDS PostgreSQL
Следующее
От: Victor Sudakov
Дата:
Сообщение: "fsync = off" in recovery