diff options
Diffstat (limited to 'roles/jails/02_postgres/tasks/main.yml')
| -rw-r--r-- | roles/jails/02_postgres/tasks/main.yml | 14 |
1 files changed, 6 insertions, 8 deletions
diff --git a/roles/jails/02_postgres/tasks/main.yml b/roles/jails/02_postgres/tasks/main.yml index 12365d0..226e734 100644 --- a/roles/jails/02_postgres/tasks/main.yml +++ b/roles/jails/02_postgres/tasks/main.yml @@ -1,5 +1,6 @@ - import_role: name: jail + tasks_from: jail_setup - name: Check if database is initialized stat: @@ -10,11 +11,6 @@ shell: /usr/local/etc/rc.d/postgresql initdb when: not _pg_data.stat.exists -- name: Enable postgresql - community.general.sysrc: - name: postgresql_enable - value: "YES" - - name: Allow LAN connections in pg_hba.conf lineinfile: path: /var/db/postgres/data18/pg_hba.conf @@ -29,14 +25,16 @@ regexp: "^listen_addresses" notify: Restart postgresql -- name: Flush handlers - meta: flush_handlers +- import_role: + name: jail + tasks_from: jail_launch - name: Create database users - shell: "su -l postgres -c \"psql -tc \\\"SELECT 1 FROM pg_roles WHERE rolname='{{ item }}'\\\"\" | grep -q 1 || su -l postgres -c \"createuser {{ item }}\"" + shell: "su -l postgres -c \"psql -tc \\\"SELECT 1 FROM pg_roles WHERE rolname='{{ item }}'\\\"\" | grep -q 1 || su -l postgres -c \"psql -c \\\"CREATE ROLE {{ item }} LOGIN PASSWORD '{{ pg_user_passwords[item] }}'\\\"\"" loop: "{{ pg_users }}" register: _pg_user changed_when: "'CREATE ROLE' in _pg_user.stdout" + no_log: true - name: Create databases shell: "su -l postgres -c \"psql -tc \\\"SELECT 1 FROM pg_database WHERE datname='{{ item.name }}'\\\"\" | grep -q 1 || su -l postgres -c \"createdb -O {{ item.owner }} {{ item.name }}\"" |