02.02. Restore database

   <<< Back   Next >>>

1. Shutdown database
[root@pg-db01]# systemctl stop postgresql-14

2. Detailed Information about last Backup:

[barman@barman-bcp]$ barman show-backup pg-db01 latest

3. Restore database

[barman@barman-bcp]$ 

barman recover --remote-ssh-command "ssh postgres@pg-db01" pg-db01 20220714T201740 /srv/postgres/data/14/

4. Doing PITR. Recovery target time: '2022-07-15 18:15:00+03:00'

[barman@barman-bcp]$ 

barman recover --remote-ssh-command "ssh postgres@pg-db01" pg-db01 20220715T175632 --target-time "2022-07-15 18:15:00.000" /srv/postgres/data/14/

5. Startup database

[root@pg-db01]# systemctl start postgresql-14

   <<< Back   Next >>>