Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1slUcV-0089LK-SS
	for pgsql-admin@arkaria.postgresql.org; Tue, 03 Sep 2024 14:35:00 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1slUcT-00CVQJ-Ow
	for pgsql-admin@arkaria.postgresql.org; Tue, 03 Sep 2024 14:34:57 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ramsveeru441@gmail.com>)
	id 1slUcT-00CVQB-Bs
	for pgsql-admin@lists.postgresql.org; Tue, 03 Sep 2024 14:34:57 +0000
Received: from mail-lj1-x22c.google.com ([2a00:1450:4864:20::22c])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <ramsveeru441@gmail.com>)
	id 1slUcR-000TTa-96
	for pgsql-admin@lists.postgresql.org; Tue, 03 Sep 2024 14:34:56 +0000
Received: by mail-lj1-x22c.google.com with SMTP id
 38308e7fff4ca-2f3e071eb64so391971fa.1
        for <pgsql-admin@lists.postgresql.org>;
 Tue, 03 Sep 2024 07:34:55 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1725374094; x=1725978894;
 darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=KGd37sf2DF/IVd7dQknYhL5jaWxBqv9YzU8FbLJIzug=;
        b=DCK08wQo3CzgWYIvav0tDdLqa1ZfjEoR1LHGdqCRPcilMesjtLlE47e1dVt5rO1W0L
         LJ1trYqTbe0hyibjxFfQwodMDzthOnbvLT6PZjqUCrsU6FM4b9jdRdBzTK/UixcF/TGX
         MMyQab7XSJ1AOzPpwzAoQM73hg90sdrFBSYFX2rydP9WI12P5u8FOIy6B+kxo4mcN1Wt
         gAMHM8iruykSK9BS6Dkw6ORmBUNHnN99UdhWsuiV2+6n98tGWhHXCpTxdzk9L7ywer3b
         0XCNFk4A5IUYFzLjfyDlQoXQHmUCe//IJFOxEUE8hCpPoNHNuBq5jqsISTtv5L7IvUbW
         OLeQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1725374094; x=1725978894;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=KGd37sf2DF/IVd7dQknYhL5jaWxBqv9YzU8FbLJIzug=;
        b=EwQt65pNQgRBZ6loz/XC8kqHAisUumOeamI4juoWMGgQ13fIVda9zfWnQVIA4AeuMH
         Rqi2yko72ulEZ3724kv+Ot5f1e9d3ClGuoHcHuUpx4rqzpgwgY4DnEXKCocbAtYAwdNq
         StCEYsymItp00uIvbWbUyA71kuc1wrVc60gtqdohafYrNrZInHCLbe6I5tsJj+qxChZk
         EzJISb5GNuqDZfOYLD0lmvGOHlN61ByeJJUEAyx5vmnltWBGsHGbypOpSIBqldm/+V4i
         Kfbf2UwoXkAxsaPKKRBgP+GvWZoOY/2lKhAeTZlYuw4uHyLsFdnOyDm2TqL2UniVii4N
         pFVQ==
X-Gm-Message-State: AOJu0YwJ+WxpTu1yHUL9hS5UaeQnR/W3jat097w222qkW0Um3thfnaoj
	WVhrM/lpfLOI1lfu0ZMDR06aYCu3VeaZF4Oqkv6AqlVcGbxkLzES+N0SeB9/8PRgfpe7aiMZwKt
	V0DFccotfssxl0G+jDEpMKnc6Ka4=
X-Google-Smtp-Source: 
 AGHT+IFWS92Z2VmSSK7TNPRr8mhx6IAzz/bYEJQCokrhVIkOXyXzkjU+Nwdd1OJNfSP1FoQZBnkR89sC2Yfejf9OpuI=
X-Received: by 2002:a05:651c:19ac:b0:2ef:1b1b:7f42 with SMTP id
 38308e7fff4ca-2f610893553mr164673221fa.36.1725374093383; Tue, 03 Sep 2024
 07:34:53 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CAJk5AtYpJdsEFNoBacupNazN=WXFGoOEaxce7yt8xbFkf+0NZA@mail.gmail.com>
In-Reply-To: 
 <CAJk5AtYpJdsEFNoBacupNazN=WXFGoOEaxce7yt8xbFkf+0NZA@mail.gmail.com>
From: rams nalabolu <ramsveeru441@gmail.com>
Date: Tue, 3 Sep 2024 09:34:42 -0500
Message-ID: 
 <CAHq7gtDZOgFdngMp5cAJxAXRmpis-vgrohi0fty+WgtyLsGh_A@mail.gmail.com>
Subject: Re: Basebackup
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f0e689062137f586"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CAHq7gtDZOgFdngMp5cAJxAXRmpis-vgrohi0fty%2BWgtyLsGh_A%40mail.gmail.com>
Precedence: bulk

--000000000000f0e689062137f586
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

The difference is that offloading resource consumption on primary while
taking backup and copy it to new server.
So it=E2=80=99s better to run it from new server


On Tue, Sep 3, 2024 at 7:31=E2=80=AFAM Rajesh Kumar <rajeshkumar.dba09@gmai=
l.com>
wrote:

> How different is basebackup from new server with primary host and rsync
> from primary,  move to new server and start cluster?
>

--000000000000f0e689062137f586
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">The difference is that offloading resource consumption on=
 primary while taking backup and copy it to new server.</div><div dir=3D"au=
to">So it=E2=80=99s better to run it from new server</div><div dir=3D"auto"=
><br></div><div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gm=
ail_attr">On Tue, Sep 3, 2024 at 7:31=E2=80=AFAM Rajesh Kumar &lt;<a href=
=3D"mailto:rajeshkumar.dba09@gmail.com">rajeshkumar.dba09@gmail.com</a>&gt;=
 wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8=
ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"auto">How diffe=
rent is basebackup from new server with primary host and rsync from primary=
,=C2=A0 move to new server and start cluster?</div>
</blockquote></div></div>

--000000000000f0e689062137f586--