From 85c7ce0d4647e0754b049dfc50858058c926ed08 Mon Sep 17 00:00:00 2001 From: Jakub Czajka Date: Tue, 16 Dec 2025 13:47:00 +0100 Subject: [PATCH] [postgres] Upgrade from 15 to 17. --- server.git/postgres.yaml | 19 ++++++++++--------- 1 file changed, 10 insertions(+), 9 deletions(-) diff --git a/server.git/postgres.yaml b/server.git/postgres.yaml index 4f1ae11..e933863 100644 --- a/server.git/postgres.yaml +++ b/server.git/postgres.yaml @@ -1,9 +1,10 @@ -# Copyright (c) 2023 Jakub Czajka +# Copyright (c) 2023-2025 Jakub Czajka # License: GPL-3.0 or later. - hosts: servers vars: repo: "{{ ansible_local.env.vars.git_home_dir }}/server.git" + ver: 17 tasks: - name: Install postgres package: @@ -15,32 +16,32 @@ command: git --work-tree=/tmp --git-dir={{ repo }} checkout main \ --force postgres/* become: true - - name: Create directory /etc/postgresql/15/main/private + - name: Create directory /etc/postgresql/VER/main/private file: - path: /etc/postgresql/15/main/private + path: /etc/postgresql/{{ ver }}/main/private state: directory become: true - - name: Copy files from /tmp/postgres to /etc/postgresq/15/main + - name: Copy files from /tmp/postgres to /etc/postgresq/VER/main copy: src: /tmp/postgres/{{ item }} - dest: /etc/postgresql/15/main + dest: /etc/postgresql/{{ ver }}/main remote_src: true become: true with_items: - pg_hba.conf - postgresql.conf - - name: Limit permissions for /etc/postgresql/15/main/private + - name: Limit permissions for /etc/postgresql/VER/main/private file: - path: /etc/postgresql/15/main/private + path: /etc/postgresql/{{ ver }}/main/private state: directory mode: 0700 owner: postgres group: postgres become: true - - name: Copy postgres' certificates /etc/postgresql/15/main/private + - name: Copy postgres' certificates /etc/postgresql/VER/main/private copy: src: "{{ ansible_local.env.vars.postgres_ssl_cert_dir }}/{{ item }}" - dest: /etc/postgresql/15/main/private + dest: /etc/postgresql/{{ ver }}/main/private mode: 0600 owner: postgres group: postgres -- 2.47.3