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
Last activity: Dec 5, 2023, 01:01 PM