Re: Basebackup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 server


On 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?

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux