Manueller Restore einer Odoo Datenbank inkl. Filestore auf Basis von Docker

$ docker stop muster-myodoo

$ scp -P 22 /root/backups-docker/odoo-test_dockerbackup_2019-01-21_17-57-04.zip root@0.0.0.0:/root/temp

$ docker exec -i muster-db psql -U myodoo -d postgres -c "drop database muster;"
# Im Postgres-Container Template Datenbank erzeugen
$ docker exec -i muster-db psql -U myodoo -d postgres -c "CREATE DATABASE muster OWNER myodoo TEMPLATE template1;"

# Backup auspacken und filestore umbenennen
$ unzip muster_dockerbackup_yyyy-mm-dd_hh-mm-ss.zip
$ cd muster/
$ mv filestore/ muster/

$ cat dump.sql | docker exec -i muster-db psql -U myodoo -d "muster"
$ rm dump.sql

$ rm -rf /opt/myodoo/muster
$ mkdir -p /opt/myodoo/muster/data/filestore
$ mv muster /opt/myodoo/muster/data/filestore

$ docker start muster-myodoo

$ cp odoo-backup.zip /var/lib/postgresql
$ chown postgres: /var/lib/postgresql/odoo-backup.zip
$ su postgres
$ psql
postgres=# ALTER DATABASE test_odoo RENAME TO bak_test_test;
postgres=# CREATE DATABASE test_odoo OWNER test_pg TEMPLATE template1;
\q

$ cd /var/lib/postgresql
$ unzip odoo-backup.zip
$ psql -U test_pg -f odoo_test/dump.sql -d test_odoo -h localhost -p 5432

$ docker start muster-myodoo