aboutsummaryrefslogtreecommitdiffstats
path: root/ansible/roles/postgres/tasks/main.yml
diff options
context:
space:
mode:
authorOle Mathias Heggem <ole@sdok.no>2017-04-19 23:16:07 +0200
committerOle Mathias Heggem <ole@sdok.no>2017-04-19 23:16:07 +0200
commit7b97188b728c85c498acc8acdce1750c472f2c85 (patch)
tree12c1436ab7eb97e9434e774671e8ffea134d61db /ansible/roles/postgres/tasks/main.yml
parentf70f65f7466a480a45a8260b35887cb7ed36b466 (diff)
parent7d404abf07d865d253ac2cfc353741e8d4af4867 (diff)
Merge remote-tracking branch 'refs/remotes/tech-server/master'
Diffstat (limited to 'ansible/roles/postgres/tasks/main.yml')
-rw-r--r--ansible/roles/postgres/tasks/main.yml31
1 files changed, 31 insertions, 0 deletions
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
+