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@xxxxxxxxx> 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 serverOn Tue, Sep 3, 2024 at 7:31 AM Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx> wrote:How different is basebackup from new server with primary host and rsync from primary, move to new server and start cluster?