amipo_documentation_backup
Ceci est une ancienne révision du document !
Table des matières
Documentation des Backup AMIPO
Todo Dump
- Changer le schema de nextcloud (ne pas laisser dans public)
- Ne dumper que le schema nextcloud
- Dumper le schema au format text et les data au format custom ?
set search_path to public,nextcloud; alter schema public rename to nextcloud; create schema public; alter role nextcloud set search_path to nextcloud;
pg_dump --username=nextcloud_backup -d nextcloud -h localhost --schema-only -n nextcloud | gzip > $BACKUP_DIR/schema-nextcloud-dump.psql.gz pg_dump --username=nextcloud_backup -d nextcloud -h localhost --data-only -n nextcloud -Fc > $BACKUP_DIR/data-nextcloud-dump.custom
Restauration d'un backup
Création de la BD dans lequel sera effectué la restauration
create role restore_user; alter role restore_user encrypted password 'foo'; alter role restore_user login; alter role restore_user set search_path to nextcloud; create database restore_nextcloud; \c restore_nextcloud; create schema nextcloud; grant usage on schema nextcloud to restore_user; grant select on all tables in schema nextcloud to restore_user; grant select on all sequences in schema nextcloud to restore_user;
Restauration de la BD
sudo mkdir /var/restore sudo chown max:max /var/restore cd /var/restore sudo chown -R max:max * sudo tar -xzf /backups/nextcloud/latest psql -U restore_user -h localhost -d restore_nextcloud -c "show search_path;" zcat schema-nextcloud-dump.psql.gz | sudo -u postgres -s psql -d restore_nextcloud sudo -u postgres -s pg_restore -d restore_nextcloud data-nextcloud-dump.custom
Duplication de l'app nextcloud
sudo cp -ar /var/www/nuage/ /var/www/restore_nuage
Edition du fichier /var/www/restore_nuage/config/config.php pour se connecter la BD:
'overwrite.cli.url' => 'https://amipo.fr/restore_nuage', 'dbname' => 'restore_nextcloud', 'dbuser' => 'restore_nextcloud', 'dbpassword' => '***',
Config Nginx
sudo cp /etc/nginc/nextcloud.conf /etc/nginc/restore_nextcloud.conf Remplacement de /nuage par /restore_nuage dans ce nouveau fichier. Ajout dans /etc/nginx/sites-available/amipo.fr de include /etc/nginx/restore-nextcloud.conf;
amipo_documentation_backup.1578734613.txt.gz · Dernière modification : 2020/01/11 09:23 de bigMax