Content-Type: multipart/alternative;
 boundary="------------PPa2yzny1r5FwW70HJyFqqdg"
Message-ID: <9c8da100-4dde-4a8d-9dff-e55c1e119f8d@netcologne.de>
Date: Mon, 9 Sep 2024 21:21:46 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Basebackup
To: pgsql-admin@lists.postgresql.org
References: 
 <CAJk5AtYpJdsEFNoBacupNazN=WXFGoOEaxce7yt8xbFkf+0NZA@mail.gmail.com>
 <CAJ9xe=viYDjheTF4AQ8O2UKjeNrjzSc=m0N6pCYaEVcY8OK_iA@mail.gmail.com>
 <CAJk5AtYOL0bh90F8HG8Z6uU6uNCmgHNASKgn3z_EJxVpZbEtWQ@mail.gmail.com>
Content-Language: en-US
From: vrms <vrms@netcologne.de>
In-Reply-To: 
 <CAJk5AtYOL0bh90F8HG8Z6uU6uNCmgHNASKgn3z_EJxVpZbEtWQ@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/9c8da100-4dde-4a8d-9dff-e55c1e119f8d%40netcologne.de>
Precedence: bulk

This is a multi-part message in MIME format.
--------------PPa2yzny1r5FwW70HJyFqqdg
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

hi Rajesh,

On 9/4/24 11:44 AM, Rajesh Kumar wrote:
>
> ... I have two openshift environments in different data centers. I 
> want to move one data from one DC to another Data center.
>
it is not 100% clear what exactly you want to achieve.
But ... if you want to migrate your postgres from location A to location 
B (that is what it somehow sounds like) I guess ...

 1. setting up a replica on the target (B) via pg_basebackup
 2. stopping your application and the old main (A)
 3. promoting the replica (B) to become the new main
 4. re-directing your application to the target (B)

could be quite efficient.

>
> On Wed, 4 Sept 2024, 13:49 Asad Ali, <asadalinagri@gmail.com> wrote:
>
>     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
>     <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?
>
--------------PPa2yzny1r5FwW70HJyFqqdg
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    hi Rajesh,<br>
    <br>
    <div class="moz-cite-prefix">On 9/4/24 11:44 AM, Rajesh Kumar wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAJk5AtYOL0bh90F8HG8Z6uU6uNCmgHNASKgn3z_EJxVpZbEtWQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <p dir="ltr">... I have two openshift environments in different
        data centers. I want to move one data from one DC to another
        Data center.</p>
    </blockquote>
    it is not 100% clear what exactly you want to achieve.<br>
    But ... if you want to migrate your postgres from location A to
    location B (that is what it somehow sounds like) I guess ...<br>
    <ol>
      <li>setting up a replica on the target (B) via pg_basebackup</li>
      <li>stopping your application and the old main (A)<br>
      </li>
      <li>promoting the replica (B) to become the new main</li>
      <li>re-directing your application to the target (B)<br>
      </li>
    </ol>
    could be quite efficient. <br>
    <br>
    <blockquote type="cite"
cite="mid:CAJk5AtYOL0bh90F8HG8Z6uU6uNCmgHNASKgn3z_EJxVpZbEtWQ@mail.gmail.com">
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">On Wed, 4 Sept 2024, 13:49
          Asad Ali, &lt;<a href="mailto:asadalinagri@gmail.com"
            moz-do-not-send="true" class="moz-txt-link-freetext">asadalinagri@gmail.com</a>&gt;
          wrote:<br>
        </div>
        <blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
          <div dir="ltr">Hi Rajesh,
            <div><br>
            </div>
            <div>Here are a few differences between basebackup and
              rsync.</div>
            <div><br>
            </div>
            <b>pg_basebackup</b> 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.
            <div>
              <div>
                <div><br>
                </div>
                <div><b>rsync </b>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.<br>
                </div>
                <div><br>
                </div>
                <div><b>You can use basebackup</b> 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.<br>
                  Network bandwidth and performance impact on the
                  primary server are not critical concerns. If you want
                  an automated process that requires less manual
                  intervention.<br>
                </div>
                <div><br>
                </div>
                <div><b>You can use rsync</b> 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.</div>
                <div><br>
                </div>
                <div>Regards,</div>
                <div>Asad Ali</div>
                <div><br>
                </div>
              </div>
            </div>
          </div>
          <br>
          <div class="gmail_quote">
            <div dir="ltr" class="gmail_attr">On Tue, Sep 3, 2024 at
              5:31 PM Rajesh Kumar &lt;<a
                href="mailto:rajeshkumar.dba09@gmail.com"
                target="_blank" rel="noreferrer" moz-do-not-send="true"
                class="moz-txt-link-freetext">rajeshkumar.dba09@gmail.com</a>&gt;
              wrote:<br>
            </div>
            <blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
              <div dir="auto">How different is basebackup from new
                server with primary host and rsync from primary,  move
                to new server and start cluster?</div>
            </blockquote>
          </div>
        </blockquote>
      </div>
    </blockquote>
  </body>
</html>

--------------PPa2yzny1r5FwW70HJyFqqdg--