Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Does pg_cron allows for timezone base trigger on RDS ?

0

Hello,

Since the pg_cron version 1.5.0 there's the possibility of using a timezone instead of the default UTC timezone. The pg_cron documentation allows for a cron.timezone settings in the postgres.conf file.

Settings that is currently not availaible in the RDS parameter group.

Does any of you had success using this ?

Topics
Database
Tags
PostgreSQL
Language
English

asked 2 years ago439 views

1 Answer
0

Hello.

As you know, RDS PostgreSQL cannot change the cron.timezone setting as of August 2024.
So I don't think it's possible to change pg_cron's timezone using cron.timezone as far as I know.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_pg_cron.html#PostgreSQL_pg_cron.parameters

EXPERT

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content