diff options
| author |  Chris Lovering <[email protected]> | 2024-09-13 16:47:18 +0100 |
|---|---|---|
| committer | Chris Lovering <[email protected]> | 2025-02-15 16:08:13 +0000 |
| commit | abe0a5eea25c8a10d967f8929729ec8faaa50254 (patch) | |
| tree | a90e2b25ec6f7107079b83c208dd21971e397cbc | |
| parent | Bump keycloak to latest version (diff) | |
Install pg_repack to all databases
| -rw-r--r-- | ansible/roles/postgres/tasks/main.yml | 3 | ||||
| -rw-r--r-- | ansible/roles/postgres/tasks/pg_repack.yml | 21 |
2 files changed, 24 insertions, 0 deletions
diff --git a/ansible/roles/postgres/tasks/main.yml b/ansible/roles/postgres/tasks/main.yml index fc57945..d4cf6af 100644 --- a/ansible/roles/postgres/tasks/main.yml +++ b/ansible/roles/postgres/tasks/main.yml @@ -121,3 +121,6 @@ - role::postgres notify: - Reload the postgres service + +- name: Install and configure pg_repack + include_tasks: pg_repack.yml diff --git a/ansible/roles/postgres/tasks/pg_repack.yml b/ansible/roles/postgres/tasks/pg_repack.yml new file mode 100644 index 0000000..907c83f --- /dev/null +++ b/ansible/roles/postgres/tasks/pg_repack.yml @@ -0,0 +1,21 @@ +--- +- name: Install pg_repack + apt: + name: + - postgresql-{{ postgres_version }}-repack + state: present + tags: + - role::postgres + - role::postgres-pg_repack + +- name: Add pg_repack to all databases + become: true + become_user: "{{ postgres_user }}" + community.postgresql.postgresql_ext: + db: "{{ item.name }}" + name: pg_repack + state: present + loop: "{{ postgres_databases }}" + tags: + - role::postgres + - role::postgres-pg_repack |