blob: 7f708a0c2fa9c6812d09cb66aab5879b3a1e4811 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
---
- 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
- 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
|
