Postgres Pro
Downloads
Home   >   mailing lists

Re: Basebackup - Mailing list pgsql-admin

From ajit wangkhem
Subject Re: Basebackup
Date
Msg-id CAMurXp0UvUTqYaRfg1R2Vrsu1VCootxaSjdisMmc6+q=yXq4zg@mail.gmail.com
Whole thread Raw
In response to Re: Basebackup  (rams nalabolu <ramsveeru441@gmail.com>)
List pgsql-admin
Tree view
To overcome performance used Peer to Peer of both machines with CAT6A cable so that you get 10GBPS speed and this does not hamer primary server because separate network used for replication and also if possible used replication slot. This was already tested in 1.6 TB data. If you have problem in storage than used ( --format=tar --gzip) in pg_basebackup and then decompress it.

Regards,
Ajit W

On Tue, Sep 3, 2024 at 8:05 PM rams nalabolu <ramsveeru441@gmail.com> wrote:
The difference is that offloading resource consumption on primary while taking backup and copy it to new server.
So it’s better to run it from new server


On Tue, Sep 3, 2024 at 7:31 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
How different is basebackup from new server with primary host and rsync from primary,  move to new server and start cluster?

pgsql-admin by date:

Previous
From: rams nalabolu
Date:
Subject: Re: Basebackup
Next
From: Laurenz Albe
Date:
Subject: Re: Basebackup