Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (1.0)
Subject: Re: Backup solution over unreliable network
From: Evan Bauer <evanbauer@mac.com>
In-Reply-To: <fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5@matrix.gatewaynet.com>
Date: Fri, 30 Nov 2018 13:22:34 -0500
Cc: pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <20801752-C311-4F70-9D03-08C5E711645C@mac.com>
References: <fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5@matrix.gatewaynet.com>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Precedence: bulk

Achilleas,

I may be over-simplifying your situation, but have you considered breaking t=
he problem into two pieces?  First backing up to a local drive and then usin=
g rsync to move those files over the unreliable network to the remote site.

Like other who have responded, I can heartily recommend pgbackrest.  But if t=
he network stinks, then I=E2=80=99d break the problem in two and leave Postg=
reSQL out of the network equation.

Cheers,

Evan

Sent from my iPhone

> On Nov 30, 2018, at 05:17, Achilleas Mantzios <achill@matrix.gatewaynet.co=
m> wrote:
>=20
> Hello,
> we've been running our backup solution for the last 5 months to a second s=
ite which has an unreliable network connection. We had problems with barman,=
 since it doesn't support backup resume, also no option to disable the repli=
cation slot, in the sense, that it is better to sacrifice the backup rather t=
han fill up the primary with WALs and bring the primary down. Another issue i=
s now supporting entirely backing up from the secondary. With barman this is=
 not possible, streaming (or archiving) must originate from the primary.So I=
 want to ask two things here :
> - Backing up to a remote site over an unreliable channel is a limited use c=
ase by itself, it is useful for local PITR restores on specific tables/data,=
 or in case the whole primary suffers a disaster. Is there any other benefit=
 that would justify building a solution for it?
> - I have only read the best reviews about PgBackRest, can PgBackRest addre=
ss those issues?
>=20
> Thank you!
>=20
> --=20
> Achilleas Mantzios
> IT DEV Lead
> IT DEPT
> Dynacom Tankers Mgmt
>=20
>=20