staging-db_playbook.yml

- hosts: staging_db_server
  become: true
  vars_files:
      - group_vars/all.yml
      - group_vars/staging.yml
      - group_vars/VAULT
      - group_vars/dbservers.yml
      - host_vars/staging-db.gvl.org.au.yml
      - secret_group_vars/stats_server_vault
  pre_tasks:
      - name: Install psycopg2 for python3
        apt:
            name: python3-psycopg2
            state: present
        become: true
  roles:
      - common
      - insspb.hostname
      - geerlingguy.pip
      - galaxyproject.postgresql
      - role: galaxyproject.postgresql_objects
        become: true
        become_user: postgres
      - dj-wasabi.telegraf