From 4e04c35f04c264d728587a54d0515eef0a42a44b Mon Sep 17 00:00:00 2001
From: Kristian Lyngstol <kly@kly.no>
Date: Wed, 19 Apr 2017 18:17:40 +0200
Subject: build/: Make room for new deployment scheme

---
 ansible/roles/postgres/tasks/main.yml | 31 +++++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)
 create mode 100644 ansible/roles/postgres/tasks/main.yml

(limited to 'ansible/roles/postgres/tasks')

diff --git a/ansible/roles/postgres/tasks/main.yml b/ansible/roles/postgres/tasks/main.yml
new file mode 100644
index 0000000..ee53327
--- /dev/null
+++ b/ansible/roles/postgres/tasks/main.yml
@@ -0,0 +1,31 @@
+- name: Install db-packages
+  apt:
+      name: "{{ item }}"
+      state: present
+  with_items:
+      - postgresql-9.4
+      - python-psycopg2
+- name: Drop postgresql-config
+  copy:
+      dest: /etc/postgresql/9.4/main/postgresql.conf
+      src: postgresql.conf
+- name: Whoami
+  become: false
+  command: whoami
+  register: whoami
+- name: Fix sudo
+  lineinfile:
+     dest: "/etc/sudoers"
+     state: present
+     line: "{{ whoami.stdout }} ALL=(postgres) NOPASSWD: ALL"
+- name: Make postgres-db
+  become_user: postgres
+  postgresql_db:
+    name: nms
+- name: Ensure a valid postgres-user
+  become_user: postgres
+  postgresql_user: 
+      db: nms
+      name: nms
+      password: risbrod
+     
-- 
cgit v1.2.3