Ceci est une ancienne révision du document !

---

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