1 Answer
- Newest
- Most votes
- Most comments
0
Hello,
Refer this article to change the time zone for Amazon RDS: https://repost.aws/knowledge-center/rds-change-time-zone#
Relevant content
asked 4 years ago
asked 2 years ago
- AWS OFFICIALUpdated 6 months ago
Thanks for suggesting to change the timezone of the database. I would prefer to leave the database in UTC though and just setting the timezone for the extension as suggested.
Yes, like you mentioned there is no parameter groups to set cron.timezone in RDS, https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_pg_cron.html#PostgreSQL_pg_cron.parameters.
Could you please check this thread and check if it works? https://stackoverflow.com/questions/73795095/how-to-run-pg-cron-job-as-per-local-time