Les scripts de backups sont entreposés ici : https://framagit.org/amipo/amipo-admin-code/tree/master/backups Actuellement il y a 2 scripts :
crontab -l -u www-data
. Cela devrait être : # Nextcloud backup 0 2 * * * ( export PGPASSWORD="XXXXX"; /var/amipo-admin-code/backups/backup_nextcloud.sh 2>&1 || /var/amipo-admin-code/backups/restore_nextcloud_maintenance.sh 2>&1 ) | mailx -s "[AMIPO Admin] Sorties de backup nocturne de Gits." admin
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 all on all tables in schema nextcloud to restore_user; grant all on all sequences in schema nextcloud to restore_user;
sudo mkdir /var/restore sudo chown max:max /var/restore cd /var/restore sudo chown -R max:max * sudo tar -xzf /backups/nextcloud/latest sudo chown www-data:www-data /var/restore/.../nextcloud/data 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
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:
'datadirectory' => '/var/restore/.../nextcloud/data', 'overwrite.cli.url' => 'https://amipo.fr/restore_nuage', 'dbname' => 'restore_nextcloud', 'dbuser' => 'restore_nextcloud', 'dbpassword' => '***',
Ajouter un cronjob
sudo mkdir -p /var/log/restore_nextcloud/ sudo chown root:www-data /var/log/restore_nextcloud/ sudo chmod 0660 /var/log/restore_nextcloud/ sudo crontab -e -u www-data */5 * * * * php -f /var/www/restore_nuage/cron.php 2>&1 /var/log/restore_nextcloud/cron.log
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;