Skip to content

Use pg_cron as HAF-maintenance service

Krzysztof Leśniak requested to merge 194-pg_cron-maintenance-service into develop
  • Creates haf_maintainer unix and postgres account
  • Conditionally enable pg_cron for normal runs in docker container (loading/dumping snapshot does not include it)
  • Postgres' max_worker_processes increased by one, because one worker is used by pg_cron process
  • Modified dump_instance.sh to dump all extensions except pg_cron

pg_cron automatically stores the data about started jobs. This can be accessed using the query select * from cron.job_run_details order by start_time desc. The job history is kept for 7 days and is scheduled to delete old entries daily.

Closes #194 (closed)

Edited by Krzysztof Leśniak

Merge request reports