92 lines
2.3 KiB
Plaintext
92 lines
2.3 KiB
Plaintext
barman recover \
|
|
--remote-ssh-command 'ssh sembla' \
|
|
--target-time="2024-02-25 18:07:00" \
|
|
aquaris_5501 20240223T180120 \
|
|
/data/restore
|
|
|
|
|
|
/app/postgres/product/16.2/bin/pg_ctl \
|
|
--pgdata=/data/restore \
|
|
-l /tmp/restore.log \
|
|
start
|
|
|
|
|
|
/app/postgres/product/16.2/bin/pg_ctl \
|
|
--pgdata=/data/restore \
|
|
-l /tmp/restore.log \
|
|
stop
|
|
|
|
|
|
barman list-backups aquaris_5501
|
|
aquaris_5501 20240227T150757 - Tue Feb 27 15:12:54 2024 - Size: 237.0 MiB - WAL Size: 191.7 MiB
|
|
aquaris_5501 20240227T145343 - Tue Feb 27 14:58:54 2024 - Size: 239.6 MiB - WAL Size: 242.8 MiB
|
|
aquaris_5501 20240227T143931 - Tue Feb 27 14:44:54 2024 - Size: 239.9 MiB - WAL Size: 242.9 MiB
|
|
|
|
après le premier backup: Tue Feb 27 02:52:33 PM CET 2024
|
|
après le 2-ème backup: Tue Feb 27 03:06:47 PM CET 2024
|
|
pendant le 3-ème backup: Tue Feb 27 03:09:10 PM CET 2024
|
|
après le 3-ème backup: Tue Feb 27 03:20:17 PM CET 2024
|
|
|
|
arrêt des inserts: Tue Feb 27 03:23:48 PM CET 2024
|
|
|
|
|
|
1. TARGET = Tue Feb 27 03:06:47 PM CET 2024
|
|
- on utilise 20240227T145343
|
|
- target time: "2024-02-27 15:06:47"
|
|
|
|
|
|
barman recover \
|
|
--remote-ssh-command 'ssh sembla' \
|
|
--target-time="2024-02-27 15:06:47" \
|
|
aquaris_5501 20240227T145343 \
|
|
/data/restore
|
|
|
|
|
|
barman recover \
|
|
--remote-ssh-command 'ssh sembla' \
|
|
--target-time="2024-02-27 15:06:47" \
|
|
aquaris_5501 20240227T143931 \
|
|
/data/restore
|
|
|
|
|
|
2. TARGET = le 1-er backup
|
|
|
|
barman \
|
|
recover --remote-ssh-command 'ssh sembla' \
|
|
aquaris_5501 20240227T143931 \
|
|
/data/restore
|
|
|
|
=> surprise! le recovr s'est fait jusqu'au dernier WAL backupé par BARMAN
|
|
|
|
|
|
barman \
|
|
recover --remote-ssh-command 'ssh sembla' \
|
|
aquaris_5501 latest \
|
|
/data/restore
|
|
|
|
|
|
jawa=> select min(t),max(t) from timeline;
|
|
min | max
|
|
----------------------------+----------------------------
|
|
2024-02-27 14:33:12.373606 | 2024-02-27 15:23:51.508241
|
|
(1 row)
|
|
|
|
|
|
|
|
Avec la clause "get-wal" il y a eu uhje restauration COMPLETE, WAL current (partiel streamé) inclus
|
|
|
|
barman \
|
|
recover --remote-ssh-command 'ssh sembla' \
|
|
--get-wal \
|
|
aquaris_5501 latest \
|
|
/data/restore
|
|
|
|
|
|
jawa=> select min(t),max(t) from timeline;
|
|
min | max
|
|
----------------------------+----------------------------
|
|
2024-02-27 14:33:12.373606 | 2024-02-27 15:24:19.508331
|
|
(1 row)
|
|
|
|
|