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.96) (envelope-from ) id 1w5jr6-003Zn5-1t for pgsql-novice@arkaria.postgresql.org; Thu, 26 Mar 2026 12:30:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5jr4-002e5z-07 for pgsql-novice@arkaria.postgresql.org; Thu, 26 Mar 2026 12:30:30 +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.96) (envelope-from ) id 1w5jr3-002e5r-2W for pgsql-novice@lists.postgresql.org; Thu, 26 Mar 2026 12:30:30 +0000 Received: from mail-oa1-x30.google.com ([2001:4860:4864:20::30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w5jr1-00000001Hix-3C5c for pgsql-novice@lists.postgresql.org; Thu, 26 Mar 2026 12:30:29 +0000 Received: by mail-oa1-x30.google.com with SMTP id 586e51a60fabf-4152698e745so320192fac.1 for ; Thu, 26 Mar 2026 05:30:27 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774528225; cv=none; d=google.com; s=arc-20240605; b=bfG+2mHyceaUWqRtU3DkaBswOnBRxR50kcJWwwCGXFa4kWYVbkezfTMdwttvBk4raE cOj1du/CtAsjX/ttEme/+EPIBxunW5dZ5Est6hOc+IZXy0RWqtWTq/bGhZ1h/HutuR1N nCnCYtIibZmq00tt4SuoOZka6geUHexeIuyk3f6UicAgiWszTOrAhV8sjv6KRJYDpLDk Bdq2tNNjzLChOShJ5IlwfHYQVR/c6VQ6mcl8HQfLXjHMwX22pR6gL778RK3/nCI44s1i NVYSkgVyc5+H1vODg/poaRDr4ndDfM1UhAn45qYui6Z4cgDYUiBoHnk0V+m4QN0U+1/p OObg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=5yOxHo2kG9XY7zJwp4CZ5zbO8wjllevxi61SgLivg28=; fh=4YP8/ObuFdNE7FLzoa2GUFMCmfYVDd3/chevNTaOUVE=; b=PL/NP798LZ5wyJV3mQOm105FYRL+TMrIKuT8r7yFWN1QmWxxE99YD8nFTxW/rJmE+I oENn2cyfaQ/ZaPbAw75vPizgvJQsSoYU7kdilv94kSQ+E/6prwmhOENQilqZJaHRr0EW rovenmzkv1MPAGkUwPUhtkhh516Fm8FxDfKvT/m3qcmroJBN1TH35sCrKsvoWrvC9UmK l6oM6pOEZ3YH/dn6KRi5GZ5iXaGps4xEbiyYuV5kHqcakbiygOVB75RmngK8TQUIcmXx C8wFjlEM1tE+rMRJJMwQ+HstYJAhswdawoE1xhphvj1O6sDaekIyneyMM1LitOjk7MQP 9ncg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774528225; x=1775133025; 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=5yOxHo2kG9XY7zJwp4CZ5zbO8wjllevxi61SgLivg28=; b=YMwAsfwUeOTIigshIgMYiezc5/7D9CSpzj4wmtOMXZtJ4Z7kiMFDEiSbgOzvaBJbnd PygzxBFU/sTI/LFJYnH4uN7YEgJVnEAD/mBzAOwjlcLdVAy0nZ9RSYfRy6M2zOq1dICD zZnHcF0zR0bO3QZJ/04EAq6InYeoB4cCIVHJy2dIZBhKDPQyw4AND3NOXdt0sJwgmIQN HxR7DiLd4XHCqwOaohCqnKDQpX6F8NGH4SiQ/muVb3S7aelRg/M5h0/odqgHkYmj+l1n hj0M6YC8GN/HrX+6CzIk49B1yGJG5WU4mTDkxWQ9M+lUZBep3bmHE1wLhcpptLBXHctC 6QYQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774528225; x=1775133025; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=5yOxHo2kG9XY7zJwp4CZ5zbO8wjllevxi61SgLivg28=; b=c9q2xyzgivYxMxZxsz7kvB0eCKPBCcvpSjAMHLiASuwn+zuPMSJoG7IdmGz4yUV/5Z YV0lWXZBDcfzajFqst6A9nEoBF9AAhhzzuxgqgnFcv4bW76pPMUJ6h+y11oTwtVZsAVx u7+60oArTuP3r9EFs/JZfy7jdenv6GVO8UYn1RFDTIEiWOEEjtZ5vUkFkTiZew6eccR+ iPcv6q3Dt+NrQ30P5pyoxHS2/lgkgMsXtcNXYwS+wnoiQjof8A9jhGZVlApSaZrsXaA+ z3rEUqGgqrLJ+ITHrLgRKBkJhvzimcIf1jWjdTqM3FlgU+s+Lae23rTujIkkwEQt2I2F iqtw== X-Gm-Message-State: AOJu0YwdKG1Gec3FLkEuWL73ZB3+DMlJwGX37pxIHvZTNPLO1CuMA1B/ l+7eMp4qVqw8FgSTSXrZcQy/BQ8NNS2wFElJ6VnwU2kmL90lQorFAOfOYaOrlY9zwZ7ch+7+ukD 8r15EKpEErzTH15Yxc9fY5zGt5nVkoFY3eA== X-Gm-Gg: ATEYQzxIo68LCCds90QczBScEZGIbaxP/m3AkgKH1pFhnFha46jYf5bje6/K0oUXT20 hoCvrj4j+S94b00GFz0q6o2PUvO9rsKhFpl7DgJMn0qGd5v0IYnB9wZHLRqYW1w1aCs/Zp84kDq QDsqv4mzKpYTETPQmKVdvPGe8EvOD4FemYER3MqeQfd/nagiXiqYZQPG6ONZ+J6QPBwaTjmyqfs T+po0xU+GjOClFPVcd0i6OE33hlLSFVqXdLZ7nsqYJ0KWHoNBJJb9HOtG08t5gi76FZpcW/iihI wSh2K7fGf2SOUA6nfRWJ1qxc3Oo3cgoZjP3xz1PX X-Received: by 2002:a05:6870:f613:b0:41c:74dc:caf1 with SMTP id 586e51a60fabf-41ca718957cmr4246785fac.49.1774528225218; Thu, 26 Mar 2026 05:30:25 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:7fcb:0:b0:625:aba4:b950 with HTTP; Thu, 26 Mar 2026 05:30:24 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Thu, 26 Mar 2026 05:30:24 -0700 X-Gm-Features: AQROBzCNFs2SCz_TvYct9Er7Y3XsFIFOOZFjVhNNynPHwEuCTJ75-9uJZhqSqA4 Message-ID: Subject: Re: Very basic question about Archive logs To: "Subramanian,Ramachandran" Cc: "pgsql-novice@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000821440064dec8c71" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000821440064dec8c71 Content-Type: text/plain; charset="UTF-8" On Thursday, March 26, 2026, Subramanian,Ramachandran < ramachandran.subramanian@alte-leipziger.de> wrote: > Further more, if I execute the PIT-recovery On Tuesday at 0005 Hours and > specify a Target recovery time of Monday 2300 Hours, then Postgres will > look at the active logs and any archive logs ( if it does not already exist > in the active logs ) that were written between Tuesday 0005 Hours and > Monday 2300 Hours and use these logs to Undo all the changes to the current > Database. Is my understanding correct? > > There is no rolling back. You deploy the base backup first to 0100 Monday, then it would apply the WAL up to the target time. David J. --000000000000821440064dec8c71 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, March 26, 2026, Subramanian,Ramachandran <ramachandran.subramanian@alte-= leipziger.de> wrote:

Further more, if I execute the PIT-recovery On Tuesda= y at 0005 Hours and specify a Target recovery time of Monday 2300 Hours, th= en=C2=A0 Postgres will look at the active logs and any archive logs ( if it does not already exist in the active logs ) that = were written between Tuesday 0005 Hours and Monday 2300 Hours and use these= logs to Undo all the changes to the current Database. Is my understanding = correct?

There is no rolling back.=C2=A0 You deploy the base backup f= irst to 0100 Monday, then it would apply the WAL up to the target time.

David J.

--000000000000821440064dec8c71--