Unable to modify cron.timezone parameter in azure flexible postgresql

Question

Hi,

We are having 100s of scheduled jobs in pg_cron which is supposed to run in CET time zone. Since default timezone of pg_cron is UTC, we are adjusting each schedule as per UTC and scheduled it. As Day light savings demands to change the schedule 2 times an year, we are forced to change it for 2 times in year manually. As a solution, we found recent version of pg_cron supports cron.timezone parameter and tried to change it. But we are facing permission denied issue even is elevated access. This parameter is not available in server parameters as well. Kindly help when we can expect this parameter as dynamic in Azure PostgreSQL flexible server.

Thanks and regards,

Manimahesh S

Answer 1

Hi @Mani Mahesh Sivakumar,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that you are facing issues with the cron.timezone parameter in pg_cron on Azure PostgreSQL flexible server. I'm sorry to hear that you are facing this issue.

As of now, the cron.timezone parameter is not available as a dynamic parameter in Azure PostgreSQL flexible server.

However, you can set the timezone parameter in your PostgreSQL configuration file (postgresql.conf) to the desired time zone. This will set the default time zone for all connections to the database.

For more Information, please refer the document: https://github.com/citusdata/pg_cron

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.