Recovery does not include partial wal file unless --get-wal is specified which implies that SSH is enabled

[allanharry]

Hi Due to security we dont want that database team can gain acces to backups in BARMAN using SSH. So we are using streaming protocol for wal files and pgbasebackup where ssh is not needed.

For the recover part we observe that transactions in partial wal file not being applied ! barman recover
--remote-ssh-command "sshpass -p xxxxxx ssh postgres@pg1"
pg1
20210124T232937
/pg_database/pg12

Doing the recover with --get-wal and allowing ssh from pg1 to barman server will include partial wal file and RPO=zero: barman recover
--get-wal
--remote-ssh-command "sshpass -p xxxxxx ssh postgres@pg1"
pg1
20210124T232937
/pg_database/pg12

If backup can be done using streaming protocol then this partial wal file should also somehow be handled during the recover to ensure RPO=zero. Are there any plans to include this in BARMAN ?

Regards Allan

[nlgtuankiet]

I can confirm that the issue exists. @mikewallace1979 is there any update on this?

[mikewallace1979]

@nlgtuankiet Thanks for confirming - I have also reproduced this. We'll get a fix into one of the upcoming releases.

[pct-cclausen]

Also ran into this, not realizing I will need a ssh connection from postgres to barman to restore partial wal files . Since my database is sitting inside a docker container that doesn't have an ssh client this complicates the setup to restore data significantly for me :(