diff options
| author | Quentin Dufour <quentin@deuxfleurs.fr> | 2022-01-28 19:11:58 +0100 |
|---|---|---|
| committer | Quentin Dufour <quentin@deuxfleurs.fr> | 2022-01-28 19:11:58 +0100 |
| commit | f3dbf47547e659f1797495b65a623382435805c0 (patch) | |
| tree | acd66d6efb0b004697568277d8aee8372ae1c6b4 /op_guide/stolon/manual_backup.md | |
| parent | 37bea48d45039ef84b4732f10f3cabe9cbb63fa1 (diff) | |
| download | infrastructure-f3dbf47547e659f1797495b65a623382435805c0.tar.gz infrastructure-f3dbf47547e659f1797495b65a623382435805c0.zip | |
Ajout de pg_verifybackup
Diffstat (limited to 'op_guide/stolon/manual_backup.md')
| -rw-r--r-- | op_guide/stolon/manual_backup.md | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/op_guide/stolon/manual_backup.md b/op_guide/stolon/manual_backup.md index 1e02ac4..fa7e13f 100644 --- a/op_guide/stolon/manual_backup.md +++ b/op_guide/stolon/manual_backup.md @@ -99,6 +99,18 @@ You should have something like that: 00000003000014AF000000C9 00000003000014AF000000CA 00000003.history archive_status ``` +Before restoring our backup, we want to check it: + +```bash +cd /tmp/sql/pg_data +cp ../backup_manifest . +# On ne vérifie pas le WAL car il semblerait que ça marche pas trop +# Cf ma référence en bas capdata.fr +# pg_verifybackup -w ../wal . +pg_verifybackup -n . + +``` + Now, We must edit/read some files before launching our ephemeral server: - Set `listen_addresses = '0.0.0.0'` in `postgresql.conf` - Add `restore_command = 'cp /mnt/wal/%f %p' ` in `postgresql.conf` @@ -290,3 +302,4 @@ https://www.cybertec-postgresql.com/en/pg_basebackup-creating-self-sufficient-ba https://www.postgresql.org/docs/14/continuous-archiving.html https://www.postgresql.org/docs/14/backup-dump.html#BACKUP-DUMP-RESTORE https://dba.stackexchange.com/questions/75033/how-to-restore-everything-including-postgres-role-from-pg-dumpall-backup +https://blog.capdata.fr/index.php/postgresql-13-les-nouveautes-interessantes/ |