copy a barman snapshot to another backup server

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: copy a barman snapshot to another backup server
Date: 2015-11-30 16:28:22
Message-ID: CAHnozTjmiTnX42Rv9-NiZG3+tKhs-pZiLi69v92VZOjY52BVmA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

We use barman for backups.
We have an on-site backup server that sits in the same rack as the other
servers, which holds a month worth of backups.

We also have an off-site backup server in another city that always holds 1
backup snapshot of all servers, to protect the data in case of a fire or
natural disaster. But i haven't included the barman backups in that yet.

What would be the best way to pull a snapshot from barman?

The snapshots are pulled by the off-site server using rsync; we have no
access from on-site to off-site. So what I'd do is restore a backup locally
on the on-site backup server and backup that from off-site.
That would be wasting some space and IO though, a snapshot is about 1TB. Is
there a more efficient way? E.g, i was hoping to somehow hardlink the local
restore, but i haven't found a way yet.

Cheers,

--
Willy-Bas Loos

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yogi Barot 2015-11-30 17:10:37 alter tablespace move feature postgresql 9.5/9/4
Previous Message Aitor Gil Martin 2015-11-30 13:31:09 Re: Linking tables from SQL Server