0

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.

0

Your Answer

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