From b02ac9aa6266e78ba2b102a19515b695cc275962 Mon Sep 17 00:00:00 2001 From: Chris Lovering Date: Sun, 16 Jan 2022 16:16:11 +0000 Subject: Add users and databases to portgres after install --- roles/postgres/tasks/main.yml | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'roles/postgres/tasks') diff --git a/roles/postgres/tasks/main.yml b/roles/postgres/tasks/main.yml index a3d7ad6..8a18bf2 100644 --- a/roles/postgres/tasks/main.yml +++ b/roles/postgres/tasks/main.yml @@ -12,3 +12,20 @@ name: '{{ postgresql_daemon }}' state: started enabled: true + +- name: Add postgres users. + community.postgresql.postgresql_user: + name: "{{ item.name }}" + login_user: "{{ item.login_user }}" + role_attr_flags: "{{ item.role_attr_flags }}" + with_items: "{{ postgresql_users }}" + become: true + become_user: "{{ postgresql_user }}" + +- name: Add postgres databases. + community.postgresql.postgresql_db: + name: "{{ item.name }}" + owner: "{{ item.owner | default(postgresql_user) }}" + with_items: "{{ postgresql_databases }}" + become: true + become_user: "{{ postgresql_user }}" -- cgit v1.2.3