---
- name: Создаем и настраиваем БД
  hosts: all
  roles:
    - database

---   ### database/tasks/main.yml

- name: Настраиваем PostgreSQL
  ansible.builtin.include_tasks: database.yml
  loop: "{{ dbname }}"

---   ### database/tasks/database.yml

- name: Создаем пользователя {{ item.user }}
  community.postgresql.postgresql_user:
    host: "{{ PGSRV1 }}"
    login_user: postgres
    login_password: "{{ PGSPASS }}"
    name: "{{ item.user }}"
    password: "{{ PGPWD }}"
    role_attr_flags: LOGIN
    # port: 5432

- name: Создаем БД {{ item.name }}
  community.postgresql.postgresql_db:
    host: "{{ PGSRV1 }}"
    login_user: postgres
    login_password: "{{ PGSPASS }}"
    name: "{{ item.name }}"
    owner: "{{ item.user }}"
    # port: 5432

- name: Создаем схему {{ item.name }} в БД {{ item.name }}
  community.postgresql.postgresql_schema:
    host: "{{ PGSRV1 }}"
    login_user: postgres
    login_password: "{{ PGSPASS }}"
    db: "{{ item.name }}"
    name: "{{ item.name }}"
    owner: "{{ item.user }}"

--- ###  database/defaults/main.yml

dbname:
 - { name: "admin_api", user: "admin_api_admin" }
 - { name: "agenda", user: "agenda_admin" }

PGSRV1: postgres.intra.local
PGSPASS: aaaa
PGPWD: Blab!