aboutsummaryrefslogtreecommitdiffstats
path: root/ansible/roles/postgres/tasks
diff options
context:
space:
mode:
Diffstat (limited to 'ansible/roles/postgres/tasks')
-rw-r--r--ansible/roles/postgres/tasks/pg_repack.yml11
1 files changed, 11 insertions, 0 deletions
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