Outils pour utilisateurs

Outils du site


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;
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

create role restore_user;
alter role restore_user encrypted password 'foo';
alter role restore_user login;
grant nextcloud to restore_user;
create database restore_nextcloud;
\c restore_nextcloud;
set search_path to nextcloud;
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
pg_restore -U restore_user -h localhost -d restore_nextcloud data-nextcloud-dump.custom
amipo_documentation_backup.1578732689.txt.gz · Dernière modification : 2020/01/11 08:51 de bigMax