Feature : add recovery window in the stanza k8s object

[fguiet]

Hi,
It would be helpful if the recovery window could be retrieved within the stanza.
What I mean is that each time a user requests a backup, the stanza should be updated using the pgbackrest info command.
Information such as the minimum and maximum recovery dates could then be collected and stored.
This would allow the GUI to display the available restore options for the user.
Regarding the pgbackrest info command, how can I run it from the pgBackRest sidecar? At the moment, the command returns an error indicating that it cannot retrieve the stanza.
Fred

PS: or getting those info via kubectl cnpg plugin's status

[l00ptr]

hi @fguiet

we already store a few information (including the "recovery window") on the Stanza:

$ kubectl describe stanzas.pgbackrest.dalibo.com stanza-sample
. ..
Status:
  Backups Count:
    Diff:  0
    Full:  1
    Incr:  0
  Recovery Window:
    First Backup:
      Archive:
        Start:  000000010000000000000003
        Stop:   000000010000000000000003
      Label:    20260416-090112F
      Lsn:
        Start:  0/3000028
        Stop:   0/3000158
      Prior:    
      Timestamp:
        Start:  1776330072
        Stop:   1776330086
      Type:     full
    Last Backup:
      Archive:
        Start:  000000010000000000000003
        Stop:   000000010000000000000003
      Label:    20260416-090112F
      Lsn:
        Start:  0/3000028
        Stop:   0/3000158
      Prior:    
      Timestamp:
        Start:  1776330072
        Stop:   1776330086
      Type:     full

Currently, we don't update or synchronise the recovery window when a backup expires or is removed. We know we should work on this. Do you think we should add more information there?

Thank you for your feedback and for testing our plugin, it means a lot to us!

[fguiet]

Hi @l00ptr

I agree with you on the fact that synchronisation is a MUST have. I mean Stanza should be synchronise with existing backups otherwise (I think) it would be useless but you said you are aware of this.

My use case was to get the max recovery pitr date. I need that date because we are working on a dbaas service allowing a user to restore a backup. The GUI must limit the date to the max recovery pitr date.

At the beginning, I was using the Stanza resource to display the number of backup and date of recovery window but then I realized that those infos where not synchronized.

So I ended up, using a kubectl command to get the backup objets.
To get the last pitr date I use this technique : #112

Here is the complete algo

1.SELECT last_archived_time AS last_archived_date FROM pg_stat_archiver
2.SELECT timestamp AS recovery_date FROM pg_last_committed_xact()
3.If last_archived_date < recovery_date (which can occur) I do a pg_switch_wal()

Thank for this great job !

frederic