public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Ron Johnson <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Re: Associating a pg_basebackup .backup file with it's saveset?
Date: Mon, 25 Aug 2025 09:27:57 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANzqJaDPO2X3XSwj1SC5FA5ybgds0Z0iehX4GpwnOft9eVfOPg@mail.gmail.com>
References: <CANzqJaDPO2X3XSwj1SC5FA5ybgds0Z0iehX4GpwnOft9eVfOPg@mail.gmail.com>

On Sat, 2025-08-23 at 09:56 -0400, Ron Johnson wrote:
> I'm archiving WAL files and taking basebackups.
> 
> At some point, when I'm ready to delete the oldest basebackup directory,
> I'll also of course need to run "pg_archivecleanup /Database/backups/wals mumble".
> 
> The .backup file is not in the pg_wal.tar file, so how do I know which .backup file to use?

One thing you can use is the "backup_label" file in the base backup.
Its first line will look like

  START WAL LOCATION: 0/B000028 (file 00000001000000000000000B)

You would have to extract the WAL file name from the text.

Yours,
Laurenz Albe

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Associating a pg_basebackup .backup file with it's saveset?
  In-Reply-To: <[email protected]>

* 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