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