diff options
| -rw-r--r-- | ansible/roles/postgres/tasks/pg_repack.yml | 11 | ||||
| -rw-r--r-- | ansible/roles/postgres/vars/main/main.yml | 1 |
2 files changed, 12 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 diff --git a/ansible/roles/postgres/vars/main/main.yml b/ansible/roles/postgres/vars/main/main.yml index 71d1873..d8f8ba9 100644 --- a/ansible/roles/postgres/vars/main/main.yml +++ b/ansible/roles/postgres/vars/main/main.yml @@ -1,6 +1,7 @@ postgres_version: "15" postgres_daemon: "postgresql@{{ postgres_version }}-main" postgres_user: "postgres" +postgres_pg_repack_cron_filename: ansible_postgres_pg_repack postgres_users: - name: site |