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 1vscUt-00AFEv-0c for pgsql-novice@arkaria.postgresql.org; Wed, 18 Feb 2026 08:01:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vscUs-00Eniv-1F for pgsql-novice@arkaria.postgresql.org; Wed, 18 Feb 2026 08:01:22 +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 1vscUs-00Enim-0F for pgsql-novice@lists.postgresql.org; Wed, 18 Feb 2026 08:01:22 +0000 Received: from mx2.alte-leipziger.de ([91.217.145.232]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vscUp-00000001KRu-3bRf for pgsql-novice@lists.postgresql.org; Wed, 18 Feb 2026 08:01:21 +0000 X-CSE-ConnectionGUID: wJ1KH/IjToa67rv3371itQ== X-CSE-MsgGUID: xsa6t9VNSS6yoBaOY86FCQ== From: "Subramanian,Ramachandran" To: "pgsql-novice@lists.postgresql.org" Subject: Please correct me - PIT - Redirected recovery Thread-Topic: Please correct me - PIT - Redirected recovery Thread-Index: AdygqwMBSBXjDyRYQduxMK9GECGk6w== Date: Wed, 18 Feb 2026 08:01:12 +0000 Message-ID: <8ee01402028e4fabb153a6420cce3a2a@alte-leipziger.de> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: EF5z2ETDrAeXSzkeZQk9rLbW4WOZNAUnj5XD/cFEQwaQ+UeH24Dz4Lhu upHpXEmLU2VRnkEujdpjybcuQlsAB7ipA0mFNtPDyGyaQXOvRx4pihtGF1HQYaINgcEzNI9jZFU 1OAyYdMNZjJ97HVOvx69eyMYvo72fErK2OKtB0zk7dj0ET35/kX0gPMfY5ZSDCMUpDZuf68CnEQ vbaWWwjW3tEPeQ6Au1q7jcr+YBl/ERuXKtTCWzQkleHToHqLtMxn+edHpR6uw6xE4+OwCoLodzV vJMoj8Hzo0Sdks/2idB+8n+rEL8g2V4f4tcqkQwrdPIcvaPIfaWzpGKWacixHg8wOTJF6WsGX0F PwZLFw0F8LHyNn1d+d3ZpXKz8e4nDpCI602q13R3KHDIoiVcrIafJ+YnZv9foS8p4LVgO5ACkzd /+l5OptjkA7ZIeC0hf2U3Gtie23dJ/NaISC/oGI00PILgpqtbo4iCakRRMU2Ke9HYvfNGVyNNwr KtrjHd2HlzhM3zNtmByZFoLAP0SZIV7PKxJ06deTKZayz4M/eUMZjxm+qIlJk5Ik5xBNiLtwE8+ yVyedAua9n033R/bgtUdALzXAfT x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--29.690500-8.000000 x-tm-snts-smtp: 3A3018F08FB7E19840BF513913D70F16ECE1AFC3A03F447781B3115E968973712000:8 x-alsentwithgood: false Content-Type: multipart/alternative; boundary="_000_8ee01402028e4fabb153a6420cce3a2aalteleipzigerde_" MIME-Version: 1.0 X-GBS-PROC: JuTN+Y2/9MV6ANvBcnAnIz52WP0qdGrijWD5u3eYelZ7+ocC0K5inWV1GIbcBPli X-GBS-PROCJOB: =?utf-8?Q?d4y+d2eQgBCDvf0mJH/D7GUzWoxMHV6HqTiUNdN1qXrJNtWPkaRooNYaOI4r?= =?utf-8?Q?ao1cXpa4RCjLgKAgqAju7+exyqwRPrIpUWlJHta6lVlbZ2ZqvDH0fR7Fng9e?= =?utf-8?Q?vB8rA4gBj7Gyej1w8x8XIM7qIW8/JVGzY1JUQMx+A4LwymF5GGM=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_8ee01402028e4fabb153a6420cce3a2aalteleipzigerde_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, Kindly excuse my beginner question. I am formulating a backup strategy for our Production environment. I use pg_basebackup ( naturally with archive logging ) . I have successfully tested a full recovery and a point in time recovery a= t the source server. I have also tested a full recovery in a secondory server with the backups= taken from the source server. My question is regarding the possibility of a PIT recovery in the seconda= ry server. 1. Is it possible to do a PIT Recovery in the secondary server WITHOU= T copying over the archive logs from the primary server IF the recovery p= oint lies WITHIN THE RANGE of the logs contained in the pg_basebackup = =3F In other words is it possible to rollforward within the range of the = logs present in pg_wal directory. 1. Where does Postgres keep track of the information about which log w= as archived at what time=3F Is there a command to get this information = from postgres=3F 1. I have not tested this yet, but logic tells me that IF I COPY over = the ARCHIVE LOGS from the source to the target server, then PIT Recovery = should be possible. Please correct me if I am wrong. Thank you in advance for your kind answers. 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_8ee01402028e4fabb153a6420cce3a2aalteleipzigerde_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

 

  Kindly excuse my beginner question= .

 

I am formulating a backup strategy for ou= r Production environment.

 

I use pg_basebackup ( naturally with arch= ive logging ) .

 

I have successfully tested a full recover= y and a point in time recovery at the source server.

 

I have also tested a full recovery in a s= econdory server with the backups taken from the source server.

 

My question is regarding the possibility = of a PIT recovery in the secondary server.

 

  1. Is it possible to do a PIT Recovery in the seconda= ry server  WITHOUT copying over the archive logs from the primary server IF the recovery point lies WITHIN THE RANGE of the logs contained= in the pg_basebackup =3F In other words is it possible to rollforward wi= thin the range of the logs present in pg_wal directory.=

 

  1. Where does Postgres keep track of the information = about which log was archived at what time=3F  Is there a command &nb= sp;to get this information from postgres=3F

 

 

  1. I have not tested this yet, but logic tells me tha= t IF I COPY over the ARCHIVE LOGS from the source to the target server, then PIT Recovery should be possible. Please correct me if I am wrong.

 

Thank you in advance for your kind answer= s.

 

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_8ee01402028e4fabb153a6420cce3a2aalteleipzigerde_--