vars.yml

---

#--- will be set by molecule
#postgresql_version: "{{ postgresql_version | default('13') }}"

postgresql_port: 5433

postgresql_databases:
  - name: foobar
    owner: baz

  - name: qux
    owner: baz
    state: absent

postgresql_users:

  # postgresql >=10 does not accept unencrypted passwords
  - name: baz
    #pass: md51a1dc91c907325c69271ddf0c944bc72
    pass: SCRAM-SHA-256$4096:En1EXwWCRrgFjvDuZ3m5WQ==$Bt4eGQmfMdiTeuz3ZArSBN4XOq+r4VRKW1HZIyxbhUo=:PMAr9udG0/5+5c+36BDO37XFgr/jMDoulhYVwy3haXc=
    encrypted: yes

  - name: zab
    #pass: md51a1dc91c907325c69271ddf0c944bc72
    pass: SCRAM-SHA-256$4096:En1EXwWCRrgFjvDuZ3m5WQ==$Bt4eGQmfMdiTeuz3ZArSBN4XOq+r4VRKW1HZIyxbhUo=:PMAr9udG0/5+5c+36BDO37XFgr/jMDoulhYVwy3haXc=
    encrypted: yes

  - name: foo
    state: absent

  - name: zabaz

postgresql_user_privileges:
  - roles: baz
    database: foobar

postgresql_database_schemas:
  - database: foobar
    state: present
    schema: acme
    owner: baz