$ 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 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/
|