public inbox for pgsql-novice@postgresql.org
help / color / mirror / Atom feedFrom: Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
To: Laurenz Albe <laurenz.albe@cybertec.at>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Subject: AW: AW: Very basic question about Archive logs
Date: Thu, 26 Mar 2026 13:42:02 +0000
Message-ID: <8a67983391a14af1ad968c2c6c2aec82@alte-leipziger.de> (raw)
In-Reply-To: <8177cb9bc419f96f09302c50eb71d92723e01b9e.camel@cybertec.at>
References: <dee8d2457c034cddb7ab7021e1caf3f7@alte-leipziger.de>
<CAKFQuwZwA=sq7xeLV032QJCzZ99NQnq8SNg4a6Y_hBxN_D=PmA@mail.gmail.com>
<5604c5c610e44a0d97daceaf5f1ae01f@alte-leipziger.de>
<8177cb9bc419f96f09302c50eb71d92723e01b9e.camel@cybertec.at>
I see two files backup_label and backup_label.old in the backups ( which I assume is the backup_label from the previous backup ) .
When I restore the base backup, from Monday 0100 Hours, Postgres will look at 0/53000028 and look for newer Logs beginning from this log file in the Archivelog dir.
Only in the archive log dir because we would have over written the active log dir. Postgres will rollforward till end of Logs OR a particular timestamp if one is specified.
Am I understanding this correctly?
What purpose does the .old serve?
LG
Ram
START WAL LOCATION: 0/53000028 (file 000000010000000000000053)
CHECKPOINT LOCATION: 0/53000060
BACKUP METHOD: streamed
BACKUP FROM: primary
START TIME: 2026-03-23 00:55:57 CET
LABEL: This is fullbackup
START TIMELINE: 1
START WAL LOCATION: 0/3D000028 (file 00000001000000000000003D)
CHECKPOINT LOCATION: 0/3D000060
BACKUP METHOD: streamed
BACKUP FROM: primary
START TIME: 2026-02-28 02:15:02 CET
LABEL: This is fullbackup
START TIMELINE: 1
Yes. That is, if the backup *ended* at 1:00 a.m.[Subramanian,Ramachandran IT-md-db] I understand what you mean
Freundliche Grüße
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 Oberursel
Vors. des Aufsichtsrats: Dr. Walter Botermann · Vorstand: Christoph Bohn (Vors.), Dr. Jürgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek
Sitz Oberursel (Taunus) · Rechtsform VVaG · Amtsgericht Bad Homburg v. d. H. HRB 1583 · USt.-IdNr. DE 114106814
Hallesche Krankenversicherung a.G., Löffelstraße 34-38, 70597 Stuttgart
Vors. des Aufsichtsrats: Dr. Walter Botermann · Vorstand: Christoph Bohn (Vors.), Dr. Jürgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Mayer, Christian Pape,
Wiltrud Pekarek, Udo Wilcsek
Sitz Stuttgart · Rechtsform VVaG · Amtsgericht Stuttgart HRB 2686 · USt.-IdNr. DE 147802285
Beiträge zu privaten Kranken- und Pflegekrankenversicherungen unterliegen nicht der Versicherungsteuer (§ 4 Nr. 5 VersStG) · Versicherungsleistungen sowie Umsätze aus Versicherungsvertreter-/Maklertätigkeiten sind umsatzsteuerfrei
Die Pflichtangaben der ALH Gruppe gemäß § 35a GmbHG bzw. § 80 AktG finden Sie hier: https://www.alte-leipziger.de/impressum
______________________
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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-novice@postgresql.org
Cc: ramachandran.subramanian@alte-leipziger.de, laurenz.albe@cybertec.at, david.g.johnston@gmail.com, pgsql-novice@lists.postgresql.org
Subject: Re: AW: AW: Very basic question about Archive logs
In-Reply-To: <8a67983391a14af1ad968c2c6c2aec82@alte-leipziger.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox