diff options
| author |  Chris Lovering <[email protected]> | 2024-09-13 16:50:45 +0100 |
|---|---|---|
| committer | Chris Lovering <[email protected]> | 2025-02-15 16:08:13 +0000 |
| commit | abc0e2fa43927f71da49313c3eb368be91cf65a3 (patch) | |
| tree | 17023fa534cbb0aa4753edfe12b95b8b45f7d610 | |
| parent | Install pg_repack to all databases (diff) | |
Add a weekly cron job to repack all databases
| -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 |