Ansible DB-pull role

Sync local PostgreSQL or MySQL database with remote.

Requirements

The following CLI commands need to be installed on your local system / Docker image:

• PostgreSQL: createdb, dropdb, pg_restore
• MySQL: mysql

The following CLI commands need to be installed on your Ansible managed node / host system:

• PostgreSQL: pg_dump
• MySQL: mysqldump

Role Variables

defaults vars declared in this module can be found here: defaults/main.yml

Example Playbook

Including an example of how to use your role (for instance, with variables passed in as parameters) is always nice for users too:

- hosts: all
  roles:
     - { role: db-pull }

License

MIT

Author Information

• ansible-db-pull, written by Erwan Richard