- name: postgresql key
  become: true
  apt_key:
    url: https://www.postgresql.org/media/keys/ACCC4CF8.asc
    state: present

- name: create variable
  command: bash -c "echo \"deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main\" | sudo tee  /etc/apt/sources.list.d/pgdg.list "
  register: repo_line

- name: add postgresql repo
  become: true
  apt_repository:
    repo: deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
    state: present

- name: Update and upgrade apt packages
  become: true
  apt:
    update_cache: yes
    cache_valid_time: 86400

- name: install prerequisites
  become: true
  apt:
    name:
    - postgresql-12
    - postgresql-client-12
    - libpq-dev
    - python-psycopg2
    state: latest
    update_cache: yes
  tags:
    - packages

- name: Upload pg_hba.conf
  copy:
    src: ../files/pg_hba.conf
    dest: /etc/postgresql/12/main/pg_hba.conf

- name: create postgresql db
  postgresql_db:
    name: "{{ name_db }}"
    state: present
  become: true
  become_user: postgres

- name: create postgresql user
  postgresql_user:
    user: "{{ user_db }}"
    password: "{{ user_pwd }}"
    role_attr_flags: "CREATEDB,NOSUPERUSER"
  become: true
  become_user: postgres

- name: Dump a single schema for an existing database
  become: true
  become_user: postgres
  copy:
    src: ../files/schema.sql
    dest: /tmp/schema.sql

- name: Run query
  become: true
  become_user: postgres
  postgresql_query:
    db: "{{ user_db }}"
    path_to_script: /tmp/schema.sql

- name: Make sure a service is running
  systemd:
    state: restarted
    enabled: yes
    daemon_reload: yes
    name: postgresql