ansible-role-dbshell

Sample Playbook

- name: Setup backup scripts
  hosts: dbshell
  become: true
  roles:
    - role: dbshell
      dbshell_user: "{{ service_user }}"
      dbshell_targets:
        - name: netbox
          target: netbox
          host: localhost
          user: netbox
          pass: XXX
          path: /home/someone/backups
          compress: true
          port: 5432
          heartbeat_url: https://example.com/heartbeat
          databases:
            - netbox
  tags:
    - never
    - dbshell