/ansible-db-restore

Ansible automation to restore databases from dumps or connection. Currently supported only PostgreSQL.

MIT LicenseMIT

Ansible Database Restore

Build Status

Automatically restore database from dump or connection.

Example, how to use, can be found at tests directory.

Install

ansible-galaxy install roquie.ansible-db-restore

Example playbook to run.

How to dump

PostgreSQL

Official documentaiton.

Example:

pg_dump -F t -O -x -d ansible-db-restore -n public > test-db.tar

Supported Databases

For now supports:

  • PostgreSQL

Supported OS

  • Ubuntu 16.04 LTS
  • Ubuntu 14.04 LTS
  • Centos 7
  • Debian 8
  • Debian 9

Vagrant

  • cd /path/to/project
  • cd tests && ansible-galaxy install -r requirements.yml && cd ..
  • vagrant up

Warning

If u want rename project, make sure to rename role (ansible-db-restore) inside tests/playbooks/vagrant.yml.

License

MIT