MIME-Version: 1.0
From: KK CHN <kkchn.in@gmail.com>
Date: Thu, 29 Aug 2024 22:12:37 +0530
Message-ID: <CAKgGyB_+T8nqBPHu8c9GrJYSJ284WG4h+AbwDurPMcwk288Jxg@mail.gmail.com>
Subject: PgBackRest Ideal N/W need to provisioned ?
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003b07690620d52ad3"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB_%2BT8nqBPHu8c9GrJYSJ284WG4h%2BAbwDurPMcwk288Jxg%40mail.gmail.com>
Precedence: bulk

--0000000000003b07690620d52ad3
Content-Type: text/plain; charset="UTF-8"

List,

I am doing a full backup  using PgBackRest from a production server to
Reposerver.

My connection is  IPSec VPN over ILL  ( 8 Mbps link) between the
 Production DB Server and  the remote RepoServer.

I understood the  bottleneck of 8 Mbps between servers. (Server NICs 10Gbps
and switch 10G)

The current size of the production DB   data dir  500GB  can grow upto 1
TB  to 2 TBs during a time span of one year from today.

Query : I have started the  backup command  and it is running (may go for
hours and days as link speed is minimal, right now it is achieved only
25GB/500 GB copied from 10:55 Hrs to  22:00 Hrs) .


What should be the ideal connectivity without over provisioning the
bandwidth, but doing a full backup must finish within acceptable time
duration.

I mean the connectivity btw. production server to Repo server
 i) ILL with SSL VPN btw  servers
ii) OR MPLS between  servers ?
iii) what should be the ideal bandwidth  required considering the data dir
size mentioned above to do a reasonable backup (Full). within a  reasonable
time window
iv)  without over provisioning and underprovisioning what should be the
ideal connectivity and its bandwidth requirement to avoid network errors
and intermittent  disconnection of links  if any?

v ) Need to perform at least one full backup in a week

Any suggestions much appreciated

Thank you ,
Krishane

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

<div dir=3D"ltr">List,<br><div><br></div><div><div>I am doing a full backup=
=C2=A0 using PgBackRest from a production server=C2=A0to Reposerver.=C2=A0=
=C2=A0</div><div><br></div><div>My connection is=C2=A0 IPSec VPN over ILL=
=C2=A0 ( 8 Mbps link) between the=C2=A0 =C2=A0Production DB Server and=C2=
=A0 the remote RepoServer.</div><div><br></div><div>I understood the=C2=A0 =
bottleneck of 8 Mbps between servers. (Server NICs 10Gbps and=C2=A0switch 1=
0G)<br></div><div><br></div><div>The current size of the production=C2=A0DB=
=C2=A0 =C2=A0data dir=C2=A0 500GB=C2=A0 can grow upto 1 TB=C2=A0 to 2 TBs d=
uring a time span of one year from today.</div><div><br></div><div>Query : =
I have started the=C2=A0 backup command=C2=A0 and it is running (may go for=
 hours and days as link speed is minimal, right now it is achieved only 25G=
B/500 GB copied from 10:55 Hrs to=C2=A0 22:00 Hrs) .</div><div><br></div><d=
iv><br></div><div>What should be the ideal connectivity without over provis=
ioning the bandwidth, but doing a full backup must finish within acceptable=
 time duration.</div><div><br></div><div>I mean the connectivity btw. produ=
ction server to Repo server</div><div>=C2=A0i) ILL with SSL VPN btw=C2=A0 s=
ervers=C2=A0</div><div>ii) OR MPLS between=C2=A0 servers ?</div><div>iii) w=
hat should be the ideal bandwidth=C2=A0 required considering the data dir s=
ize mentioned above to do a reasonable backup (Full). within a=C2=A0 reason=
able time window</div><div>iv)=C2=A0 without over provisioning=C2=A0and und=
erprovisioning what should be the ideal connectivity and its bandwidth=C2=
=A0requirement to avoid network errors and intermittent=C2=A0 disconnection=
 of links=C2=A0 if any?</div><div><br></div><div>v ) Need to perform at lea=
st one full backup in a week=C2=A0</div><div><br></div><div>Any suggestions=
 much appreciated</div><div><br></div><div>Thank you ,</div><div>Krishane</=
div></div></div>

--0000000000003b07690620d52ad3--