Creates a container for PostgreSQL 9.5 for Vagrant+VirtualBox or Docker which takes nightly backups.
The database name will be the name of the directory you checkout the repository into, to create a database called 'myapp-db' run:
git clone https://github.com/HarryR/vagrant-psql.git myapp-db
To get started with Docker, run:
make docker-build docker-create docker-psql
To get started with Vagrant, run:
make vagrant-install vagrant-up
A random login and password are chosen when provisioned, these are stored in the data/conf directory, run make credentials to display them.
Daily backups are made for a week, and then each sundays backups for a month are kept in the backups directory, to setup backups add a cron job for the container type you chose:
@daily make -C /path-to/this-dir/ vagrant-backup
@daily make -C /path-to/this-dir/ docker-backup
Each Sunday's backups will be kept, and the past 7 days will be kept, resulting in files like:
backups/20161203.tar.xzbackups/20161210.tar.xzbackups/20161217.tar.xzbackups/20161218.tar.xzbackups/20161219.tar.xzbackups/20161220.tar.xzbackups/20161221.tar.xzbackups/20161222.tar.xzbackups/20161223.tar.xz
You cannot restore the data from a Docker container into a Vagrant instance or visa versa. What you do with the backups is your business, but I suggest encrypting and uploading to the cloud with transfer.py.
Restore from the latest available snapshot is possible, put the .tar.xz file into the backups/ directory and run:
make restore
To destroy the box, and all runtime data, but will not delete backups:
make xxx-destroy-data
To automatically start a Vagrant container at boot, use:
@reboot make -C /path-to/this-dir/ vagrant-up