Unable to run at proper timezone. I want to run two things

  1. bash scripts
  2. 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.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy