public inbox for [email protected]
help / color / mirror / Atom feedFrom: Asad Ali <[email protected]>
To: Rajesh Kumar <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Basebackup
Date: Wed, 4 Sep 2024 13:19:27 +0500
Message-ID: <CAJ9xe=viYDjheTF4AQ8O2UKjeNrjzSc=m0N6pCYaEVcY8OK_iA@mail.gmail.com> (raw)
In-Reply-To: <CAJk5AtYpJdsEFNoBacupNazN=WXFGoOEaxce7yt8xbFkf+0NZA@mail.gmail.com>
References: <CAJk5AtYpJdsEFNoBacupNazN=WXFGoOEaxce7yt8xbFkf+0NZA@mail.gmail.com>
Hi Rajesh,
Here are a few differences between basebackup and rsync.
*pg_basebackup* is easier, as it's a single command with PostgreSQL
support. Data consistency is automatically ensured by postgresql. It
transfers the entire database, potentially high network bandwidth is
required. It is less flexible, due to mostly predefined options.
*rsync *is more complex, it requires multiple manual steps. This method
requires stopping or ensuring the primary server's data directory is in a
consistent state before starting the synchronization, Which can cause
downtime or performance impact. It requires careful handling to ensure data
consistency. It is more efficient with bandwidth, as it only transfers
changes. It is more flexible with control over what gets copied.
*You can use basebackup* if you want a straightforward, reliable way to
create a base backup. If you are looking for a method that integrates
directly with PostgreSQL's replication capabilities.
Network bandwidth and performance impact on the primary server are not
critical concerns. If you want an automated process that requires less
manual intervention.
*You can use rsync* if you have specific requirements for how the data
should be copied (e.g., selective file copying). If you need more control
over the synchronization process or want to optimize for minimal network
usage. If you have a large dataset and want to minimize the data transfer
by only copying changes after an initial sync. If you are comfortable with
handling data consistency and can manage the additional complexity.
Regards,
Asad Ali
On Tue, Sep 3, 2024 at 5:31 PM Rajesh Kumar <[email protected]>
wrote:
> How different is basebackup from new server with primary host and rsync
> from primary, move to new server and start cluster?
>
view thread (9+ messages) latest in thread
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], [email protected], [email protected]
Subject: Re: Basebackup
In-Reply-To: <CAJ9xe=viYDjheTF4AQ8O2UKjeNrjzSc=m0N6pCYaEVcY8OK_iA@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