From 6e9bbdca08f2bf97af556b921722881a7b442ec2 Mon Sep 17 00:00:00 2001 From: Zack Cerza Date: Mon, 27 Feb 2023 16:37:32 -0700 Subject: [PATCH] paddles: Tell postgres to listen on all interfaces Signed-off-by: Zack Cerza --- roles/paddles/tasks/setup_db.yml | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/roles/paddles/tasks/setup_db.yml b/roles/paddles/tasks/setup_db.yml index 573194e..d377035 100644 --- a/roles/paddles/tasks/setup_db.yml +++ b/roles/paddles/tasks/setup_db.yml @@ -1,4 +1,17 @@ --- +- name: Listen on all interfaces + postgresql_set: + name: listen_addresses + value: "*" + become_user: postgres + register: pg_listen + +- name: Restart postgres to listen on all interfaces + service: + name: postgresql + state: restarted + when: pg_listen is changed + - name: Create the postgresql database postgresql_db: name: paddles -- 2.39.5