Sample Header Ad - 728x90

pg_cron timezone issue, unable to run at specified time

1 vote
1 answer
1325 views
Unable to run at proper timezone. I want to run two things 1. bash scripts 2. Stored procedure For both case I found it runs at the wrong time. Instead of 1 AM and 3 AM pg_cron runs at a different time. Why could that be? At PostgreSQL timezone +6 pg_cron log also show that it runs at +6 timezone but actually it runs at 9PM (21:00). How actually pg_cron get that time? SELECT cron.schedule('00 15 * * * ','/main/backup/archive.sh'); SELECT cron.schedule('00 15 * * *', $$ call archiver( 10, 'tbl_main','tbl_archiver')$$); **Note:** Though I found syntax error for script running but it is not main issue for me.
Asked by Sheikh Wasiu Al Hasib (283 rep)
Sep 18, 2022, 03:57 AM
Last activity: Dec 5, 2023, 01:01 PM