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 1w5jXJ-003ZRk-3C for pgsql-novice@arkaria.postgresql.org; Thu, 26 Mar 2026 12:10:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5jXI-002a78-0n for pgsql-novice@arkaria.postgresql.org; Thu, 26 Mar 2026 12:10:04 +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.96) (envelope-from ) id 1w5jXH-002a70-2O for pgsql-novice@lists.postgresql.org; Thu, 26 Mar 2026 12:10:04 +0000 Received: from mx1.alte-leipziger.de ([91.217.145.231]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w5jXF-000000018Vg-1M5C for pgsql-novice@lists.postgresql.org; Thu, 26 Mar 2026 12:10:03 +0000 X-CSE-ConnectionGUID: U4lHZ73tT/a2bZCHCsbQmQ== X-CSE-MsgGUID: l+GpOI2SSqCxO+xwNd9Bug== From: "Subramanian,Ramachandran" To: "pgsql-novice@lists.postgresql.org" Subject: Very basic question about Archive logs Thread-Topic: Very basic question about Archive logs Thread-Index: Ady9E4vMWdi/xu3yThaEs5n2fA38Jg== Date: Thu, 26 Mar 2026 12:09:50 +0000 Message-ID: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: OcgHo5wAKs4NBW00na8JVO9VsdrlGzy3Q6/DFZugyt1bYv6Kt+uF2PU7 2nYVxvYN4D6lW82JZVEb8xI2OD3Z7eyDy8V8lTWUZBiPr4EU8TBRpObkR9DMwkekR3VSvOYV/RG KW3143PTl1EohDK9ptobN1tobeZ1qVGs/GsqOCuYAPmNKDWsW0BLBqTl41fL7nPFud0vsSyb1bL Pk+wAcHC/3/XeSSzXhU9IBYcMFyd1akh0Sg+q4f+JOzIOycbNPtPGelsKOu4jR+YHA5wQ5g88bU mIVqNBpM1Fh0nmiO4Bwcr2Wnqs9wgjKq2eYHyXoBjNCJF/iXbFPnKxAOPp4WQ7NXi5HKVjdOUJG vwdveqJngukTeEViUYepLoXxhcsamvyr8NorYSqeAiCmPx4NwMidYBYDjITpLzP5snaeb1Sov4g zE3CFDv9PZnFdJGmK33HBg813LTssSm1xhCSzpCTxnYVTGnXFftwZ3X11IV0= x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--22.319400-8.000000 x-tm-snts-smtp: 4F463D3FD361FE1292C7724295D6289F885E9AAC39FCF5CDB7BD207001AB057E2000:8 x-alsentwithgood: false Content-Type: multipart/alternative; boundary="_000_dee8d2457c034cddb7ab7021e1caf3f7alteleipzigerde_" MIME-Version: 1.0 X-GBS-PROC: Fwr9X//Hq0ilpTqmaFOcogc4k/R2ObXgzTLvss5TUvq7naYx0dlChZWPVYX5LrMz X-GBS-PROCJOB: =?utf-8?Q?Ozuyjrnr0crZOoTwSDBlSdXkagxQRfrCNQ9wEvlQ6pVF5+IGnAHVhUsdgkgV?= =?utf-8?Q?KToAiY2ULk5a3/NPOyXFnOgEq+91uN51UMoCRoZTdAM9j6n4HIdeCjo6pgZr?= =?utf-8?Q?Cck5wQWzo7+pvC9WXlu1X+sqN7KxP7F1GYu0W/Na8fnVo+NT42o=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_dee8d2457c034cddb7ab7021e1caf3f7alteleipzigerde_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hallo, Newbie here. Kindly forgive my ignorance. A question about archive l= ogs. If I make a pg_basebackup on Monday (backup ended ) at 0100 Hours and h= ave all the archive logs from this time onwards till the next backup on T= uesday (backup ended) at 0100 Hours, I could theoretically go to any PIT = between Monday 0100 Hours to Tuesday 0100Hours . Is my understanding co= rrect=3F 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 exi= st 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 curre= nt Database. Is my understanding correct=3F In Postgres PIT recovery, there is only rollback allowed ... No roll forw= ard allowed =3F For example Could I restore the backup from Monday 0100 = Hours and somehow rollforward the logs=3F Additionally, where does postgres keep a record of which log was cut at w= hat time and which active log was archived at what time to be reused =3F LG Ram Freundliche Gr=FC=DFe i. A. Ramachandran Subramanian Zentralbereich Informationstechnologie Alte Leipziger Lebensversicherung a.G. Hallesche Krankenversicherung a.G. Alte Leipziger Lebensversicherung a.G., Alte Leipziger-Platz 1, 61440 Obe= rursel Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcs= ek Sitz Oberursel (Taunus) =B7 Rechtsform VVaG =B7 Amtsgericht Bad Homburg v= . d. H. HRB 1583 =B7 USt.-IdNr. DE 114106814 =20 Hallesche Krankenversicherung a.G., L=F6ffelstra=DFe 34-38, 70597 Stuttg= art Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek Sitz Stuttgart =B7 Rechtsform VVaG =B7 Amtsgericht Stuttgart HRB 2686 = =B7 USt.-IdNr. DE 147802285 Beitr=E4ge zu privaten Kranken- und Pflegekrankenversicherungen unterlieg= en nicht der Versicherungsteuer (=A7 4 Nr. 5 VersStG) =B7 Versicherungsle= istungen sowie Ums=E4tze aus Versicherungsvertreter-/Maklert=E4tigkeiten = sind umsatzsteuerfrei =20 =20 Die Pflichtangaben der ALH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 Akt= G finden Sie hier: https://www.alte-leipziger.de/impressum=20 ______________________ ALH Gruppe Alte Leipziger-Platz 1, 61440 Oberursel Tel.: +49 (6171) 66-4882 Fax: +49 (6171) 66-800-4882 E-Mail: ramachandran.subramanian@alte-leipziger.de www.alte-leipziger.de www.hallesche.de --_000_dee8d2457c034cddb7ab7021e1caf3f7alteleipzigerde_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hallo,

 

     Newbie here. Kin= dly forgive my ignorance. A question about archive logs.

 

If I make a pg_basebackup on Monday (back= up ended )  at 0100 Hours  and have all the archive logs from t= his time onwards till the next backup on Tuesday (backup ended) at 0100 Hours, I could theoretically go to any PIT between Monday 0100 Hours to =  Tuesday 0100Hours .  Is my understanding correct=3F

 

Further more, if I execute the PIT-recove= ry 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 ) tha= t were written between Tuesday 0005 Hours and Monday 2300 Hours and use t= hese logs to Undo all the changes to the current Database. Is my understa= nding correct=3F

 

In Postgres PIT recovery, there is only r= ollback allowed … No roll forward allowed =3F  For example Cou= ld I restore the backup from Monday 0100 Hours and somehow rollforward th= e logs=3F

 

 

Additionally, where does postgres keep a = record of which log was cut at what time and which active log was archive= d at what time to be reused =3F

 

 

LG


Ram


Freundliche Gr=FC=DFe


i. A. Ramachandran Subrama= nian =20

Zentralbereich Informationst= echnologie

=20

Alte Leipziger Lebensversicherung a. G.<= /SPAN>

Hallesche Krankenversicherung a. G.

=20

______________________

ALH Gruppe
Alte Leipziger-Platz 1, 614= 40 Oberursel
Tel: +49 (6171) 66-4882
Fax: +49 (6171) 66-800-4882E-Mail: ramachandran.subramanian@alte-leipziger.de
www.alte-leipziger.de
www.hallesche.de

Alte Leipziger Lebensversich= erung a. G., Alte Leipziger-Platz 1, 61440 Oberursel

Vors. des Aufsichtsra= ts: Dr. Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrg= en Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexand= er Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Oberursel (Taunus) =B7 = Rechtsform VVaG =B7 Amtsgericht Bad Homburg v. d. H. HRB 1583 =B7 USt.-Id= Nr. DE 114106814


Hallesche Krankenversicherun= g a. G., L=F6ffelstra=DFe 34-38, 70597 Stuttgart

Vors. des Aufsichtsrats: Dr.= Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrgen Bier= baum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Maye= r, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Stuttgart =B7 Rechtsfor= m VVaG =B7 Amtsgericht Stuttgart HRB 2686 =B7 USt.-IdNr. DE 147802285

Beitr=E4ge zu privaten Krank= en- und Pflegekrankenversicherungen unterliegen nicht der Versicherungste= uer (=A7 4 (1) Nr. 5 b VersStG) =B7 Versicherungsleistungen sowie Ums=E4t= ze aus Versicherungsvertreter-/Maklert=E4tigkeiten sind umsatzsteuerfrei<= /SPAN>


= Pflichtangaben der A= LH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 AktG --_000_dee8d2457c034cddb7ab7021e1caf3f7alteleipzigerde_--