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 1tpTsB-006FFZ-Ao for pgsql-general@arkaria.postgresql.org; Tue, 04 Mar 2025 15:07:55 +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 1tpTsA-00HS6R-2V for pgsql-general@arkaria.postgresql.org; Tue, 04 Mar 2025 15:07:54 +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 ) id 1tpTs9-00HS5F-My for pgsql-general@lists.postgresql.org; Tue, 04 Mar 2025 15:07:53 +0000 Received: from mail-oo1-xc2f.google.com ([2607:f8b0:4864:20::c2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tpTs4-000v2O-1J for pgsql-general@lists.postgresql.org; Tue, 04 Mar 2025 15:07:51 +0000 Received: by mail-oo1-xc2f.google.com with SMTP id 006d021491bc7-600131846b1so1195450eaf.0 for ; Tue, 04 Mar 2025 07:07:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741100867; x=1741705667; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=5x7yLRvzMtMH78rpSGvjUCA7BHeokIjjJWe//9ucxXA=; b=QWgI/tgLbtBcW+ubryxIinNKJ27cyaSMt2m8nYSch34s1M/bAomffjsaRd+I2Qi8lR 54276jHEBRXy8hiSSllTETCdZMIu0fcI2u9FkkLXLvO1WmaAFX2KdJy9ES/iXmGfOlr1 un9hvn+q+3uc6yHRDlnla3j60D9FZp55TqonFwiz4qvT0xEvbpo1Gv2FePqhFdSs8JUI RR7NdSZVlDjAujEiW65BIkHNzKNwfgvMt0R0taQfHJVjM/0o19TqZ3gvFVEiPvFqpwgj VUS6amcLcDG6yNk3RTrAQama0ILzgp9Saf+s0gJWqPMzyslkfhJlb7GQ/eKpHT/Ytkiu a80g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741100867; x=1741705667; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=5x7yLRvzMtMH78rpSGvjUCA7BHeokIjjJWe//9ucxXA=; b=vmlZHZPrxrHzqotwxwuz3/iZ1UYfUG1qD3au9cKxKj73UNr5Odea5XC2ZeqhAQKaiO snIKhr1Q1Oefu6prcjI6tdqvyWBx947vOFmGdbMEgMB7YvOVfApfRfkwO75CSujc+c4L nC+yRKZaMnz1ToJkzOkH1ZFn/MoqTE+lEFZuTACu855Uf1rpqRIpauS27jfG65o6vfMW Etv4I7W0RehNfx2QPDKgyyuP/zloHX5NTcs7EV04mg1ZHgrXc+uJWgyhQ/cCviW5OJss V5kXzL2LR2QIAo6V8tFma2IrXEd808Ixrg63kUX/ZMTT6TGoHymF+OB69lLjeK6nXzTS 5LDw== X-Forwarded-Encrypted: i=1; AJvYcCU+LQ+MSEHE2ht7kD8HgDnUZUkEzBhLmKWuxvT3Mz79L7MCw/VU4xfA/dFRtDhJDKiuL4u7t4Dyl4WUrCY8@lists.postgresql.org X-Gm-Message-State: AOJu0Yyz3fGb7UYKIfgFdnjA2Z3VDyoHr/eoi1a/0C5lr+/DbCv3zmjG xLjCd7yy0BCkqpwws8yKLBJI91Ga2oQsaDA8goHdKQcUl+3ChIfVCuW2J3biKep7TggCmhJVt01 krLzcnuF0vVVweFEZy9Cp3kMku2s= X-Gm-Gg: ASbGnctHHe9xnYf5+bV4p+YTZ5vUP3g8pOUOpnJvhp8ZNEUPQ3KW22yJ/yLN2UVYAZI Ky3nEM1mWC5NHr2gI3Ufqx41UofkihZ487YvNtLNl0vHz4giR4zGCf4a8PazaqpA0p2hmx5UCIl iO/z5jBYcAccK8ta0bjppuagQp X-Google-Smtp-Source: AGHT+IGH7B9W6eFXttcPnlgwesKLSTos7p9tMbNflo/TuEj+PHtEAaSzxR5ElA09BkNHpho7mTDCvygBGdisRGp8WdQ= X-Received: by 2002:a05:6820:229c:b0:600:16a6:42d8 with SMTP id 006d021491bc7-60024e97382mr2963610eaf.4.1741100867367; Tue, 04 Mar 2025 07:07:47 -0800 (PST) MIME-Version: 1.0 Received: by 2002:ac9:7a88:0:b0:589:13f9:e937 with HTTP; Tue, 4 Mar 2025 07:07:45 -0800 (PST) In-Reply-To: References: From: "David G. Johnston" Date: Tue, 4 Mar 2025 08:07:45 -0700 X-Gm-Features: AQ5f1JrEL723h5pJk3Z6aoBTCld8i1HPcjk6mHKwnGUwiO6cdvxIkw4dpPm3N8s Message-ID: Subject: Re: Review my steps for rollback to restore point To: chandan Kumar Cc: Laurenz Albe , "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000b7be42062f85a21c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b7be42062f85a21c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, March 4, 2025, chandan Kumar wrote: > Thank you for your answer. I want to clarify one more doubt. Can PITR b= e > achieved without applying Base Backup > The point-in-time you choose must be in the future relative to whatever data files you are applying WAL on top of. That is only possible of you=E2= =80=99ve backed up the data files at some point in the past and use that backup. David J. --000000000000b7be42062f85a21c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, March 4, 2025, chandan Kumar <chandan.issyoga@gmail.com> wrote:
Thank you for your answer.=C2=A0 I want to = clarify one more doubt.=C2=A0 Can PITR be achieved without applying Base Ba= ckup

The point-in-time you choose mus= t be in the future relative to whatever data files you are applying WAL on = top of.=C2=A0 That is only possible of you=E2=80=99ve backed up the data fi= les at some point in the past and use that backup.

David J.

--000000000000b7be42062f85a21c--