Unable to run at proper timezone. I want to run two things
- bash scripts
- Stored procedure
For both case I found it run at different time. Instead of 1 AM and 3 AM pg_corn runs another time. Why it is run at different time? At PostgreSQL timezone +6 pg_corn log also show that it runs at +6 timezone but actually it runs at 9PM(21pm). How actually pg_corn 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.