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)


