Associating a basebackup and it's .backup WAL file

From: cen <imbacen(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Associating a basebackup and it's .backup WAL file
Date: 2017-07-13 08:30:14
Message-ID: 67218b56-850f-ddca-f507-b0f140839a4a@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

Given a basebackup base.tar.gz and an archive of WAL files, is there any
way to find out which .backup WAL file is associated with the basebackup
from command line?

My use case is for a retention policy bash script which:

-deletes all basebackups older than X days

-runs pg_archivecleanup for the oldest basebackup

I just don't know how to find out which WAL to feed to pg_archivecleanup
at this point.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2017-07-13 09:26:59 Re: Associating a basebackup and it's .backup WAL file
Previous Message Michael Paquier 2017-07-13 08:15:21 Re: Monitoring of a hot standby with a largely idle master