---
- name: Create db user
  ansible.builtin.include_tasks:
    file: './postgres/create_user.yml'
  vars:
    user: "{{ app }}"
    password: "password"

- name: Create database
  ansible.builtin.include_tasks:
    file: './postgres/create_database.yml'
  vars:
    database: "{{ app }}"

- name: Give user permissions on database
  ansible.builtin.include_tasks:
    file: './postgres/give_user_full_privs.yml'
  vars:
    database: "{{ app }}"
    user: "{{ app }}"