amipo_documentation_backup
Ceci est une ancienne révision du document !
Documentation des Backup AMIPO
Restauration d'un backup
create role restore_user; alter role restore_user encrypted password 'foo'; alter role restore_user login; create database restore_nextcloud; \c restore_nextcloud create schema restore; grant all on schema restore to restore_user; alter role restore_user set search_path to restore;
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 nextcloud-schema.psql.gz | psql -U restore_user -h localhost -d restore_nextcloud
grant connect on nextcloud to nextcloud_backup; grant usage on schema public to nextcloud_backup; grant select on all tables in schema public to nextcloud_backup; grant select on all sequences in schema public to nextcloud_backup;
amipo_documentation_backup.1578678241.txt.gz · Dernière modification : 2020/01/10 17:44 de bigMax