Cron Job Timezone Issue

[Tech-MGRV]

I made cron job as below.
And it works on UTC +0
Is there a way to change timezone for cron job?

===

select
cron.schedule(
'config',
'0 0 * * *',
$$
update ...
$$
)

[GaryAustin1]

This seems to indicate that is how it works and no option to change. Just from googling...
citusdata/pg_cron#16

[vongohren]

Things have changed now: citusdata/pg_cron#16 (comment)

Can we unanswer and ask for an upgrade from supabase to support this somehow?

[GaryAustin1]

supabase/postgres#634
Supabase tried to upgrade and had issues and backed it out.

[vongohren]

Ah, I guess it will either take time or never come then :P ?

[GaryAustin1]

I don't know what their plan is. You could generate an issue in supabase/postgres and link that along with your needs. That is now two features missing (second resolution the other).

[vongohren]

There are an issue for update pg_cron, so just piggybacking on that. See you have been there as well :D