Der Odoo Container muss während der Zeit gestoppt werden.

$ docker stop muster-myodoo


$ scp -P 22 /root/backups-docker/muster_dockerbackup_yyyy-mm-dd_hh-mm-ss.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=# CREATE DATABASE muster OWNER muster_pg TEMPLATE template1;
\q

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

Related articles

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.


Related issues



Rechtliche Hinweise / Impressum





$ docker start muster-myodoo