search

vince7lf / aerial_wildlife_detection

Tools for detecting wildlife in aerial images using active learning
MIT License
0 stars 0 forks source link

Procédure de Backup / Restore de BD AIDE+MELCC de Google Cloud #22

Open vince7lf opened 2 years ago

vince7lf commented 2 years ago

in progress, using local virtualbox docker container

vince7lf commented 2 years ago

new help file backup.md

vince7lf commented 2 years ago

To backup & restore database, connect inside the container and run the psql/pg_dump/pg_restore commands under the postgres service account. refer to backup.md

vince7lf commented 2 years ago

For the images, list the docker volumes and inspect them : 

ubuntu@tes2:/opt$ sudo docker volume ls
DRIVER    VOLUME NAME
local     aide_db_data
local     aide_images

ubuntu@tes2:/opt$ sudo docker volume inspect aide_images
[
    {
        "CreatedAt": "2021-09-27T01:17:22Z",
        "Driver": "local",
        "Labels": {},
        "Mountpoint": "/app/var/lib/docker/volumes/aide_images/_data",
        "Name": "aide_images",
        "Options": {},
        "Scope": "local"
    }
]

Mountpoint points to the host data location.

refer to backup.md

vince7lf commented 2 years ago

continuing, retrieving all the steps. testing the cmd and details tmr between arbutus images and local vbox.

vince7lf commented 2 years ago

Va pouvoir être tester, l'image docker peut-ête de nouveau builé et erreur Python est fixé. Mais baisse de priorité, dev des favoris prioritaires.

vince7lf commented 2 years ago

complété. backup restore de toute la BD dans l'instance vbox; et certaines images de projet transférer. test

nettoyage des projets fait avec commandes dans instance de gcp.