aboutsummaryrefslogtreecommitdiffstats
path: root/ansible/roles/postgres/tasks/main.yml
blob: ee53327c1a1cd32a1bb79871f74608c3015980f4 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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