Message-ID: <27ff6d69809fe9090b4f8a3bfa0f30e9670b0d1a.camel@cybertec.at>
Subject: Re: Associating a pg_basebackup .backup file with it's saveset?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ron Johnson <ronljohnsonjr@gmail.com>, Pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Mon, 25 Aug 2025 09:27:57 +0200
In-Reply-To: 
 <CANzqJaDPO2X3XSwj1SC5FA5ybgds0Z0iehX4GpwnOft9eVfOPg@mail.gmail.com>
References: 
	<CANzqJaDPO2X3XSwj1SC5FA5ybgds0Z0iehX4GpwnOft9eVfOPg@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/27ff6d69809fe9090b4f8a3bfa0f30e9670b0d1a.camel%40cybertec.at>
Precedence: bulk

On Sat, 2025-08-23 at 09:56 -0400, Ron Johnson wrote:
> I'm archiving WAL files and taking basebackups.
>=20
> At some point, when I'm ready to delete the oldest basebackup directory,
> I'll also of course need to run "pg_archivecleanup=C2=A0/Database/backups=
/wals mumble".
>=20
> The .backup file is not in the=C2=A0pg_wal.tar file, so=C2=A0how do I kno=
w 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