public inbox for [email protected]  

help / color / mirror / Atom feed

From: KK CHN <[email protected]>
To: pgsql-general <[email protected]>
Subject: PgBackRest Ideal N/W need to provisioned ?
Date: Thu, 29 Aug 2024 22:12:37 +0530
Message-ID: <CAKgGyB_+T8nqBPHu8c9GrJYSJ284WG4h+AbwDurPMcwk288Jxg@mail.gmail.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: PgBackRest Ideal N/W need to provisioned ?
  In-Reply-To: <CAKgGyB_+T8nqBPHu8c9GrJYSJ284WG4h+AbwDurPMcwk288Jxg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox