[GENERAL] Associating a basebackup and it's .backup WAL file - Mailing list pgsql-general

From cen
Subject [GENERAL] Associating a basebackup and it's .backup WAL file
Date
Msg-id 67218b56-850f-ddca-f507-b0f140839a4a@gmail.com
Whole thread Raw
Responses Re: [GENERAL] Associating a basebackup and it's .backup WAL file  (Michael Paquier <michael.paquier@gmail.com>)
List 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.



pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [GENERAL] Monitoring of a hot standby with a largely idle master
Next
From: Michael Paquier
Date:
Subject: Re: [GENERAL] Associating a basebackup and it's .backup WAL file