search

EnterpriseDB / barman

Barman - Backup and Recovery Manager for PostgreSQL
https://www.pgbarman.org/
GNU General Public License v3.0
2.06k stars 191 forks source link

Backing up Windos works, but restore fails due to UNIX assumptions #892

Closed einhverfr closed 8 months ago

einhverfr commented 8 months ago

Backing up on Windows sorks fine aside from the problems documented in a past bug report. Restore however fails rather catastrophically.

The problem I encountered was "Could not execute remote command ssh ...." When focusing on the logs, the 'true' command failed, as it would in Windows. This would have happened via call to fs.ping(). Reviewing the file (fs.py) found that all of the calls in this map to UNIX commands but there are no Windows equivalents. In this regard, this means that while you can back up a Windows database, you cannot restore it with Barman. Therefore one has to come up with a manual process of copying files, extracting WAL segments, etc.

martinmarques commented 8 months ago

This is properly documented: 

Remote recovery is not supported for Windows servers, so you must recover your cluster locally in the Barman server and then copy all the files on a Windows server or use a folder shared between the PostgreSQL server and the Barman server.

The docs also mention that This feature is still experimental.

There are no plans to add support for Windows.