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

Barman cannot restore to Windows host in most cases #896

Open einhverfr opened 8 months ago

einhverfr commented 8 months ago

Barman can backup a Windows host but restoration is more complicated. There are several problems here:

  1. Tablespace directories get screwed up because of different path semantics This is true whether the directories are stored on Linux or on Windows via NFS (the only way of getting around the path semantics issue on restore)
  2. Barman restore assumes the presence of UNIX file and other utilities that do not exist on Windows, including true, mv, and others.

The first would probably be fixed by some sort of normalization of paths before storing tablespaces (or of just handling the differences). This requires an actual effort to port the application to Windows, though.