blob: 61befa54a45fbfed5efb6dfbdeed51138de898d2 (
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
32
33
34
35
|
- name: Install db-packages
apt:
name: ['postgresql', 'python-psycopg2', 'sudo']
state: present
- name: Drop postgresql-config
copy:
dest: /etc/postgresql/9.6/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
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
- name: Import SQL
become_user: postgres
shell: psql nms < /opt/gondul/ansible/roles/postgres/files/schema.sql
|
