backups

We have successfully created backups.

When using compose-scriptorium we like to use

docker-compose exec database sh -c 'pg_dumpall -U $POSTGRES_USER' > `date +"%Y-%m-%dT%H:%M:%S%z"`-`cd src && git rev-parse HEAD`-degrowth-scriptorium.sql
XZ_OPT=-9 tar cJf `date +"%Y-%m-%dT%H-%M-%S%z"`-`cd src && git rev-parse HEAD`-degrowth-scriptorium-state.tar.xz data assets

Locally

TIMESTAMP=$(date +%Y%m%d_%H%M%S%Z)
dokku config dbp2016-live > $TIMESTAMP-degrowth-scriptorium.cfg
dokku postgresql:dump dbp2016-live db_dbp2016 > $TIMESTAMP-degrowth-scriptorium.sql

Remotely

~ $
TIMESTAMP=$(date +%Y%m%d_%H%M%S%Z)
~ $ sudo su
almereyda # tar cvf $TIMESTAMP-degrowth-scriptorium.tar /var/lib/docker/volumes/0d78aeff608a6254f5c4af09853f03fb849c7010d269f642caeab864d56aaf41/_data
almereyda # chown almereyda:almereyda $TIMESTAMP-degrowth-scriptorium.tar

Again locally

sftp almereyda@apps.ecobytes.net:/home/almereyda/$TIMESTAMP-degrowth-scriptorium.tar .

Restore

Files:

root@panda /data/domains/scriptum.degrowth.net/BACKUP # tar -xvf 20171130_222402CET-degrowth-scriptorium.tar --strip-components=6 -C data/

Database: