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 ) id 1slSmc-007vGC-7F for pgsql-admin@arkaria.postgresql.org; Tue, 03 Sep 2024 12:37:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1slSmb-00BJ4K-2C for pgsql-admin@arkaria.postgresql.org; Tue, 03 Sep 2024 12:37:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1slSma-00BJ3z-Mw for pgsql-admin@lists.postgresql.org; Tue, 03 Sep 2024 12:37:16 +0000 Received: from mail-vk1-xa31.google.com ([2607:f8b0:4864:20::a31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1slSmY-000Rvx-Fc for pgsql-admin@lists.postgresql.org; Tue, 03 Sep 2024 12:37:15 +0000 Received: by mail-vk1-xa31.google.com with SMTP id 71dfb90a1353d-4fea2546b31so1386684e0c.2 for ; Tue, 03 Sep 2024 05:37:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1725367033; x=1725971833; 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=wRHgW1NWLPIlOkGw7l7rG23gMabHBpj/hPSbdB6OzCc=; b=Dhb87nJPWn+iIeZlNBnPVH7SqbL9SRfI5q0BB7yEeCDG1zxDxMCqvAwfpM9icx8axu PmLalGxKDN/+qOyVqpfW+M/yrwQtq1m0nLnB5K7QDZrnK10A/6pCRrmYFVLXOAsLbx0R y3kYDfD2TfCjn2bR5HfKhLmHg4t8f3PNyLSk8wWW7VdlCVZEIzFUsBU8LLjiDiUjAG3j CCBNuAqITGhbdi396+uLyNph+2jnUm1eBOk6aofTw+YmXX1rYzyRUtpWsbCgCrxZxTdZ Uol1xL47nC9kQOtMx+p5NEFeZ6jWvPWmLovUhN7Xnu9L4utTy+tN/5kffNSB0GzPGwXx 78PQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725367033; x=1725971833; 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=wRHgW1NWLPIlOkGw7l7rG23gMabHBpj/hPSbdB6OzCc=; b=Jmbs2BmiTt/T7PeRN2kFZB+atWt6gn7EUTq8eq6sZhfBpzGnQAVKUSvnjAxENIk/ho 9+eFXZthyMqoKynDCwkex8c9maq7NZ97lJBv0Iz7ph38uGjH21/vo0VsGJthEQ9uXg+h 70DG/XuCutAQlvdBYPt9cRYHCz+YHW1KPfsPkodM3Fmz5ENtjjHhuHzOOyiq6dmFNBO6 kbA56shqLmqwJTUMSuIC+Qdob2JR+JTUoechJrTtX6hwHCcKonTbAX5VuP130Z5/wUFZ XI/ojiSlPED4f4GZUqtAR5x4VslHz+2w5r9rMF8VlgQtSXqvcVjaYA09wL1O2P2IEkNW xrqg== X-Gm-Message-State: AOJu0YzIO5hw6nMNK2Ln6HXmlXl4yTrJ/iWsV2ubN/X45haxk1fKgm50 wBSVetsY4XQ5LxfVqmzA3UfCLOscW7CHffnOcN/pHpH8mP4aEo7NMfSyVmtitdYsbfcYrhcJyTL r291P42hlekPScLL2VHl+F5cQreY= X-Google-Smtp-Source: AGHT+IFo9vXka8bSL68vhxJtLUPiw4EBHeFLjKEJFbbogAoLIxaPGB7OcO9qJmQh4FkhMdkeRYziRHIfr9rG4gaNEkg= X-Received: by 2002:a05:6122:20a1:b0:4f5:2276:1366 with SMTP id 71dfb90a1353d-4ffe4a58f0dmr15746818e0c.3.1725367033393; Tue, 03 Sep 2024 05:37:13 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Kashif Zeeshan Date: Tue, 3 Sep 2024 17:37:02 +0500 Message-ID: Subject: Re: Basebackup To: Rajesh Kumar Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000002233310621365127" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002233310621365127 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Rajesh Are you talking above backup taken with pg_basebackup with WAL Archiving enabled? If yes then you can start a server on it on the new host. Regards Kashif Zeeshan On Tue, Sep 3, 2024 at 5:31=E2=80=AFPM Rajesh Kumar wrote: > How different is basebackup from new server with primary host and rsync > from primary, move to new server and start cluster? > --0000000000002233310621365127 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Rajesh

Are you talking above=C2= =A0backup taken with pg_basebackup with WAL Archiving enabled?
If= yes then you can start a server on it on the new host.

Regards
Kashif Zeeshan

On Tue, Sep 3, 2024 at 5:31=E2= =80=AFPM Rajesh Kumar <ra= jeshkumar.dba09@gmail.com> wrote:
How different is basebackup from= new server with primary host and rsync from primary,=C2=A0 move to new ser= ver and start cluster?
--0000000000002233310621365127--