We have installed EDB BART tool in our environment and incremental backup enbled. Backup is happenning as expected. But after some days when we see output of bart show-backups output is not in sorted order by date.
Reason why we need this to be in sorted order is we have a automatic backup script which takes the latest backup as 3rd line. Which assumes 3rd line in bart show-backups is latest backup.
PFB screenshot for the bart show-backup output for your referrence.
It should show in descending order.
Could you please share the output of the following command.
bart SHOW-BACKUPS -s proddb
Also, share the BART version and bart configuration file.
Thank you for your response.
PFB for the bart SHOW-BACKUPS -s proddb output
Still outputs are not in descending order.
bart.cfg as below
bart_host = firstname.lastname@example.org
backup_path = /bartbkp/bart-2.4
pg_basebackup_path = /usr/edb/as11/bin/pg_basebackup
xlog_method = stream
# thread_count should be more than 1 for stream for PG9.6 and lower
thread_count = 2
retention_policy= 37 DAYS
logfile = /var/log/edb/bart.log
scanner_logfile = /var/log/edb/bart_scanner.log
archive_command = 'scp %p %h:%a/%f'
host = 192.168.32.168
user = bart
cluster_owner = enterprisedb
allow_incremental_backups = enabled
port = 5465
backup_name = bck_%year%month%day
I have tested the same on my local machine and the show-backups is in descending order.
Could please share the screenshot of ls -ltrh command.
$ls -ltrh /usr/edb/as11/bin/pg_basebackup/proddb/
Could you please share the screenshot of "ls -lrth /bartbkp/bart-2.4/proddb/"
The file listing under the BART backup catalog parent directory.
Hi Vijay, We have found that there is only an issue with the 21st Sep backup which is not showing in the correct order.
We have also tested the same scenario on our end, however, we are always getting the show-backups output in descending order only.
Thank you for your reply, A month before also we faced the same issue.
That time we have taken seperate full backup then continued with the incremental backup.
I will try to sort the show-backups according the date and use it in script file
Vijay P Bhat