[PATCH v7 04/12] Setup postgres with ansible

[Claudio Bantaloukas via Sourceware Forge]

From: Claudio Bantaloukas <claudio.bantaloukas@arm.com>

This role installs multiple postgres versions from the upstream
deb repositories, ensures that the forgejo database and user
are available on all versions and that configuration is applied
consistently.
A full backup of the database should be taken before applying the role
for the first time.
---
 SETUP                                         |  36 -
 .../15/main/conf.d/01-pgsql-tuning.conf       |  21 -
 .../etc/postgresql/15/main/pg_hba.conf        | 109 ---
 .../etc/postgresql/15/main/postgresql.conf    | 815 ------------------
 packages                                      |   1 -
 provisioning/group_vars/all/postgres.yml      |  30 +
 provisioning/group_vars/all/time.yml          |   4 +
 .../host_vars/forge-production/postgres.yml   |  25 +
 .../forge-test.rdfm.org/postgres.yml          |  24 +
 .../host_vars/forge-test/postgres.yml         |  24 +
 provisioning/playbook.yml                     |   2 +
 provisioning/requirements.yml                 |   2 +
 .../defaults/main.yml                         |  94 ++
 .../handlers/main.yml                         |  18 +
 .../sourceware_forge_postgres/tasks/main.yml  | 101 +++
 .../tasks/pg_version_files.yml                |  85 ++
 .../tasks/pg_version_service.yml              |  17 +
 .../tasks/pg_version_user_dbs.yml             |  36 +
 .../templates/pg_hba.conf.j2                  |   8 +
 19 files changed, 470 insertions(+), 982 deletions(-)
 delete mode 100644 config-files/etc/postgresql/15/main/conf.d/01-pgsql-tuning.conf
 delete mode 100644 config-files/etc/postgresql/15/main/pg_hba.conf
 delete mode 100644 config-files/etc/postgresql/15/main/postgresql.conf
 create mode 100644 provisioning/group_vars/all/postgres.yml
 create mode 100644 provisioning/group_vars/all/time.yml
 create mode 100644 provisioning/host_vars/forge-production/postgres.yml
 create mode 100644 provisioning/host_vars/forge-test.rdfm.org/postgres.yml
 create mode 100644 provisioning/host_vars/forge-test/postgres.yml
 create mode 100644 provisioning/roles/sourceware_forge_postgres/defaults/main.yml
 create mode 100644 provisioning/roles/sourceware_forge_postgres/handlers/main.yml
 create mode 100644 provisioning/roles/sourceware_forge_postgres/tasks/main.yml
 create mode 100644 provisioning/roles/sourceware_forge_postgres/tasks/pg_version_files.yml
 create mode 100644 provisioning/roles/sourceware_forge_postgres/tasks/pg_version_service.yml
 create mode 100644 provisioning/roles/sourceware_forge_postgres/tasks/pg_version_user_dbs.yml
 create mode 100644 provisioning/roles/sourceware_forge_postgres/templates/pg_hba.conf.j2

-------------- next part --------------
A non-text attachment was scrubbed...
Name: v7-0004-Setup-postgres-with-ansible.patch
Type: text/x-patch
Size: 58125 bytes
Desc: not available
URL: <https://sourceware.org/pipermail/forge/attachments/20251001/d1dff9ba/attachment.bin>