From abc0e2fa43927f71da49313c3eb368be91cf65a3 Mon Sep 17 00:00:00 2001 From: Chris Lovering Date: Fri, 13 Sep 2024 16:50:45 +0100 Subject: Add a weekly cron job to repack all databases --- ansible/roles/postgres/tasks/pg_repack.yml | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'ansible/roles/postgres/tasks') diff --git a/ansible/roles/postgres/tasks/pg_repack.yml b/ansible/roles/postgres/tasks/pg_repack.yml index 907c83f..7f708a0 100644 --- a/ansible/roles/postgres/tasks/pg_repack.yml +++ b/ansible/roles/postgres/tasks/pg_repack.yml @@ -19,3 +19,14 @@ tags: - role::postgres - role::postgres-pg_repack + +- name: Add cronjob for running pg_repack on all databases + cron: + name: "Run pg_repack on all databases" + special_time: "weekly" + job: "pg_repack -a" + user: "{{ postgres_user }}" + cron_file: "{{ postgres_pg_repack_cron_filename }}" + tags: + - role::postgres + - role::postgres-pg_repack -- cgit v1.2.3