From f5e3ab81ac2d6810b6df0be1b798f5c9100032ac Mon Sep 17 00:00:00 2001 From: slinderud Date: Sun, 13 Jan 2019 23:19:22 +0100 Subject: Fixed ansible postgres bug --- ansible/roles/postgres/tasks/main.yml | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'ansible/roles/postgres/tasks') diff --git a/ansible/roles/postgres/tasks/main.yml b/ansible/roles/postgres/tasks/main.yml index 9adeafe..6283a75 100644 --- a/ansible/roles/postgres/tasks/main.yml +++ b/ansible/roles/postgres/tasks/main.yml @@ -1,3 +1,6 @@ +# Postgres +# https://github.com/ansible/ansible/issues/16048#issuecomment-229012509 +# - name: Install db-packages apt: name: "{{ item }}" @@ -28,12 +31,27 @@ become_user: postgres postgresql_db: name: nms + # https://github.com/ansible/ansible/issues/16048#issuecomment-229012509 + become: true + become_user: postgres + vars: + ansible_ssh_pipelining: true - name: Ensure a valid postgres-user become_user: postgres postgresql_user: db: nms name: nms password: risbrod + # https://github.com/ansible/ansible/issues/16048#issuecomment-229012509 + become: true + become_user: postgres + vars: + ansible_ssh_pipelining: true - name: Import SQL become_user: postgres shell: psql nms < /opt/gondul/ansible/roles/postgres/files/schema.sql + # https://github.com/ansible/ansible/issues/16048#issuecomment-229012509 + become: true + become_user: postgres + vars: + ansible_ssh_pipelining: true -- cgit v1.2.3