Recovery using Barman in Ubuntu and a Postgres Server in a Windows Based as main.

35 views
Skip to first unread message

Brayan Muñoz

unread,
Feb 17, 2021, 1:03:27 PM2/17/21
to Barman, Backup and Recovery Manager for PostgreSQL
Hi guys, how can I recover from my backups in Barman if i'm using my main postgres server in a Windows based. 

In the documentation I read that we can't perform a remote recovery using a Windows based server. But what u recommend would be an alternative to perform a recovery in this scenario ? 

Thanks, Brayan Muñoz from Dominican Republic.

Luca Ferrari

unread,
Feb 17, 2021, 3:01:29 PM2/17/21
to Barman, Backup and Recovery Manager for PostgreSQL
On Wed, Feb 17, 2021 at 7:03 PM Brayan Muñoz <Bray...@hotmail.com> wrote:
>
> Hi guys, how can I recover from my backups in Barman if i'm using my main postgres server in a Windows based.
>
> In the documentation I read that we can't perform a remote recovery using a Windows based server. But what u recommend would be an alternative to perform a recovery in this scenario ?

I've never tried, but I suspect that the main problem with remote
recovery is the need of an ssh server, so I would guess that if you
install and configure and ssh server on windows you will be able to do
a remote recovery.
However, as a quick approach, I would mount (e.g., via SAMBA) a
windows folder and do a local recovery over such folder, that will be
"immediatly" visible over the windows machine.
Same thing if you decide to use a network folder.
Last, you can always recover on the local barman machine, e.g., in
/tmp/my-recovery, and copy the folder across the network.

Hope this helps.
Luca

Brayan Muñoz

unread,
Feb 18, 2021, 2:06:43 PM2/18/21
to Barman, Backup and Recovery Manager for PostgreSQL
Thanks sir, I'm using Samba and its okay to share the recovery files. 

Now I just have to put that recovery folder in place of my data folder on postgres directoy ? 
Reply all
Reply to author
Forward
0 new messages