MIME-Version: 1.0
References: <CAHr8x_sQww+XNAFoHkyjYKJYq3CVcQLxJL0yaY3GHNzO3YV+bw@mail.gmail.com>
 <afhm58YUGhbwCbNE@azor.tzirechnoy.ru>
In-Reply-To: <afhm58YUGhbwCbNE@azor.tzirechnoy.ru>
From: masheed ullah <masheedullah@gmail.com>
Date: Mon, 4 May 2026 12:58:54 +0300
Message-ID: <CAHr8x_vygxU0onst=Fto8rGZjRHBz=mefospzziRVN5TXvJkwQ@mail.gmail.com>
Subject: Re: Postgres DB backup is taking too much time
To: Ilya Anfimov <ilan@tzirechnoy.com>, pgsql-performance@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000012bb340650fafb22"
Archived-At: <https://www.postgresql.org/message-id/CAHr8x_vygxU0onst%3DFto8rGZjRHBz%3DmefospzziRVN5TXvJkwQ%40mail.gmail.com>
Precedence: bulk

--00000000000012bb340650fafb22
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thank you every one for your output.

Although pgBeckRest has no more support.
Should I suggest starting testing backup and restore with pgBectRest?
I did not find any 3rd Party tool.

On Mon, May 4, 2026 at 12:29=E2=80=AFPM Ilya Anfimov <ilan@tzirechnoy.com> =
wrote:

> On Sun, May 03, 2026 at 12:42:21PM +0300, masheed ullah wrote:
> >    Hi,
> >    We have a database of 20TB, and it's taking almost 24 hours to
> complete.
> >    While full restore takes 28 hours. Although we have HA enabled with
> >    primary and multiple replica's.
> >    So we need a solution/tool to reduce the RTO, incase of disk failure=
/
> >    Human error for data/tables deletion.
> >
> >    We are using Barman for backup.
>
>  First, you'd need engineers to measure -- what's going on.
>  Who  is the slowest part? The network (most probable)? The post-
> gres replication process? The disk that postgres reads? The  bar-
> man  itself?  Receiver  disks/S3  daemon/etc?  TLS  of one of the
> above?
>  Measures is the key. Then the solutions may be searched.
>
> btw, a modern postgres can definitely supply 1GB/s to barman on a
> modern  system.   This  is  not a much, and probably could be im-
> proved by special tricks like rsync or manual prefetch or  incre-
> mental  copies  --  however,  it's less than 6 hours estimate and
> therefore is fine for you.
>
> >    My question is "Are there any tools like ZDLRA appliances for Oracle=
"
> to
> >    reduce the RTO to less than 10 hours".
> >    Best Regards,
> >    Khattak
>
>
>

--00000000000012bb340650fafb22
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Thank you every one=C2=A0for your output.=
<br><br>Although pgBeckRest has no more support.=C2=A0<div>Should I suggest=
 starting testing backup and restore with=C2=A0pgBectRest?<br>I did not fin=
d any 3rd Party tool.</div></div><br><div class=3D"gmail_quote gmail_quote_=
container"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, May 4, 2026 at 12:=
29=E2=80=AFPM Ilya Anfimov &lt;<a href=3D"mailto:ilan@tzirechnoy.com">ilan@=
tzirechnoy.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd=
ing-left:1ex">On Sun, May 03, 2026 at 12:42:21PM +0300, masheed ullah wrote=
:<br>
&gt;=C2=A0 =C2=A0 Hi,<br>
&gt;=C2=A0 =C2=A0 We have a database of 20TB, and it&#39;s taking almost 24=
 hours to complete.<br>
&gt;=C2=A0 =C2=A0 While full restore takes 28 hours. Although we have HA en=
abled with<br>
&gt;=C2=A0 =C2=A0 primary and multiple replica&#39;s.<br>
&gt;=C2=A0 =C2=A0 So we need a solution/tool to reduce the RTO, incase of d=
isk failure/<br>
&gt;=C2=A0 =C2=A0 Human error for data/tables deletion.<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 We are using Barman for backup.<br>
<br>
=C2=A0First, you&#39;d need engineers to measure -- what&#39;s going on.<br=
>
=C2=A0Who=C2=A0 is the slowest part? The network (most probable)? The post-=
<br>
gres replication process? The disk that postgres reads? The=C2=A0 bar-<br>
man=C2=A0 itself?=C2=A0 Receiver=C2=A0 disks/S3=C2=A0 daemon/etc?=C2=A0 TLS=
=C2=A0 of one of the<br>
above?<br>
=C2=A0Measures is the key. Then the solutions may be searched.<br>
<br>
btw, a modern postgres can definitely supply 1GB/s to barman on a<br>
modern=C2=A0 system.=C2=A0 =C2=A0This=C2=A0 is=C2=A0 not a much, and probab=
ly could be im-<br>
proved by special tricks like rsync or manual prefetch or=C2=A0 incre-<br>
mental=C2=A0 copies=C2=A0 --=C2=A0 however,=C2=A0 it&#39;s less than 6 hour=
s estimate and<br>
therefore is fine for you.<br>
<br>
&gt;=C2=A0 =C2=A0 My question is &quot;Are there any tools like ZDLRA appli=
ances for Oracle&quot; to<br>
&gt;=C2=A0 =C2=A0 reduce the RTO to less than 10 hours&quot;.<br>
&gt;=C2=A0 =C2=A0 Best Regards,<br>
&gt;=C2=A0 =C2=A0 Khattak<br>
<br>
<br>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><div dir=3D"=
ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div><br></div><br></div></=
div></div>

--00000000000012bb340650fafb22--