As per the above document, AWS is not supporting PG_CRON extension.
SELECT * FROM rds.allowed_extensions
The above SQL is giving erorrs but the below SQL is giving 1 row output of *.
It sounds like I do not have any extensions installed.
I remember like installing 1 extension in the past but I do not remember the details.
From: John Scalia <jayknowsunix@xxxxxxxxx>
Sent: Wednesday, July 19, 2023 8:13 PM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: How to schedule long running SQL job
Do: select * from rds.allowed_extensions; and see if it’s in your version support. I don’t quite recall which versions supports it other than v.12.X where X is another value like 4, 5, or 6. If it is in the list, try: create extension pg_cron; note you may need superuser to create it.
Sent from my iPad
On Jul 19, 2023, at 7:57 PM, M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote: