diff options
| author | Quentin Dufour <quentin@deuxfleurs.fr> | 2022-01-28 18:44:07 +0100 |
|---|---|---|
| committer | Quentin Dufour <quentin@deuxfleurs.fr> | 2022-01-28 18:44:07 +0100 |
| commit | 37bea48d45039ef84b4732f10f3cabe9cbb63fa1 (patch) | |
| tree | 74275e548edca582a22017a097f942fef992be56 /op_guide | |
| parent | 89937f2107f9b0ed5b7cd407a29cbca1efbb5104 (diff) | |
| download | infrastructure-37bea48d45039ef84b4732f10f3cabe9cbb63fa1.tar.gz infrastructure-37bea48d45039ef84b4732f10f3cabe9cbb63fa1.zip | |
Finalize manual backup
Diffstat (limited to 'op_guide')
| -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 4cbc055..1e02ac4 100644 --- a/op_guide/stolon/manual_backup.md +++ b/op_guide/stolon/manual_backup.md @@ -269,6 +269,19 @@ zstdcat -vv dump-* | \ Because we want to be extra careful, we specifically asked to crash on every error and do not want to change this behavior. So, instead, we simply remove any entry that contains the specific regex stated in the previous command.* +Check that the backup has been correctly restored. +For example: + +```bash +docker exec -ti postgres psql +#then type "\l", "\c db-name", "select ..." +``` + +## Finally, store it safely + +```bash +rsync --progress -av /tmp/sql/{*.tar.gz,backup_manifest,dump-*} backup/target +``` ## Ref |