PITR time slots are not set properly on the Web Console
Summary
Cluster data initialization uses backups ordered alphabetically to setup PITR time slots, no matter the time a backup was finally stored.
Steps to reproduce
- Create a new SGBackup and give it a name starting with
z
. - Wait for the first backup to complete and then create a new SGBackup and give it a name starting with
a
. - Go to Create new SGCluster.
- On the Initialization tab, on the Backups section, note that the Backups are ordered alphabetically, which means the backup starting with
a
will appear first even though it was created later than backup starting withz
. - Select the backup starting with
a
. - The PITR datepicker will allow you to select a time between the backup
a
and the next backup, no matter their chronological order. - Now select the backup starting with
z
. - Since that backup is the last of the list, there is no other backup after it, and the PITR select won't work.
Expected Behaviour
PITR datepicker should use the last backup based on time, not on alphabetical order.
Environment
- StackGres version:1.3.0
Edited by Luis Garcia