- name: Install packages to support postgres
  apt:
    name: [
      'libssl-dev',
      'libpq-dev',
      'libz-dev',
      'libexpat1-dev',
      'postgresql-client',
      'postgresql-contrib',
      'postgresql',
      'python3-psycopg2',
    ]
    state: present

- name: Start & enable postgres
  service:
    name: postgresql
    state: started
    enabled: true

- name: Create db user account for gitea
  postgresql_user:
    name: "{{ database.user }}"
    password: "{{ database.pass }}"
    state: present
  become_user: postgres
  become: true

- name: Create gitea database
  postgresql_db:
    name: "{{ database.name }}"
    owner: "{{ database.user }}"
    state: present
  become_user: postgres
  become: true