dev-db_playbook.yml

- hosts: dev_db_server
  become: true
  vars_files:
      - group_vars/all.yml
      - group_vars/dev.yml
      - group_vars/VAULT
      - group_vars/dbservers.yml
      - host_vars/dev-db.gvl.org.au.yml
      - secret_group_vars/stats_server_vault
  vars:
    - db_first_run_conditions: False
  pre_tasks:
    - name: Install psycopg2 for python3
      apt:
          name: python3-psycopg2
          state: present
    - name: override postgresql_objects_privileges if data directory does not yet exist
      set_fact:
          postgresql_objects_privileges: "{{ postgresql_objects_privileges_first_run }}" 
      when: "{{ db_first_run_conditions|d(False) }}"
  roles:
      - common
      - insspb.hostname
      - geerlingguy.pip
      - galaxyproject.postgresql
      - role: galaxyproject.postgresql_objects
        become: true
        become_user: postgres
      - dj-wasabi.telegraf