From eabcf10ede6f9eee77b85f537cef023f89111f9d Mon Sep 17 00:00:00 2001 From: "Ole Mathias Aa. Heggem" Date: Sun, 5 Nov 2017 23:33:04 +0100 Subject: influx/chart and ansible --- ansible/roles/postgres/tasks/main.yml | 18 +++++++++++++----- 1 file changed, 13 insertions(+), 5 deletions(-) (limited to 'ansible/roles/postgres/tasks/main.yml') diff --git a/ansible/roles/postgres/tasks/main.yml b/ansible/roles/postgres/tasks/main.yml index ee53327..14174bd 100644 --- a/ansible/roles/postgres/tasks/main.yml +++ b/ansible/roles/postgres/tasks/main.yml @@ -5,10 +5,16 @@ with_items: - postgresql-9.4 - python-psycopg2 + - sudo - name: Drop postgresql-config copy: dest: /etc/postgresql/9.4/main/postgresql.conf src: postgresql.conf +- name: Add db to hosts + lineinfile: + dest: /etc/hosts + line: "127.0.0.1 db" + state: present - name: Whoami become: false command: whoami @@ -24,8 +30,10 @@ name: nms - name: Ensure a valid postgres-user become_user: postgres - postgresql_user: - db: nms - name: nms - password: risbrod - + postgresql_user: + db: nms + name: nms + password: risbrod +- name: Import SQL + become_user: postgres +shell: psql nms < /opt/gondul/ansible/roles/postgres/files/schema.sql -- cgit v1.2.3