cancel
Showing results for 
Search instead for 
Did you mean: 

EDB BART show backup issue

Level 3 Adventurer

EDB BART show backup issue

Hi,

 

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.bart show.png

 

Please help

Tags (1)
8 REPLIES 8
EDB Team Member

Re: EDB BART show backup issue

Hi Vijay,

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.

Level 3 Adventurer

Re: EDB BART show backup issue

Thank you for your response.

 

PFB for the bart SHOW-BACKUPS -s proddb output bart-proddb.png

 

Still outputs are not in descending order.

bart.cfg as below

 

[BART]
bart_host = enterprisedb@mpgweprdpgdb09.mcmpgegy.com
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
#wal_compression= enabled
archive_command = 'scp %p %h:%a/%f'
mbm_scan_timeout=1000

[proddb]
host = 192.168.32.168
user = bart
cluster_owner = enterprisedb
allow_incremental_backups = enabled
port = 5465
backup_name = bck_%year%month%day

 

EDB Team Member

Re: EDB BART show backup issue

Hi Vijay,

 

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/

Level 3 Adventurer

Re: EDB BART show backup issue

Hi,

 

Thank you for your reply, and sorry for late reply,

There is no /usr/edb/as11/bin/pg_basebackup/proddb/ directory.

 

 

 

 

 

 

 

 

EDB Team Member

Re: EDB BART show backup issue

Hi  Vijay,

Could you please share the screenshot of "ls -lrth /bartbkp/bart-2.4/proddb/"

The file listing under the BART backup catalog parent directory.

Level 3 Adventurer

Re: EDB BART show backup issue

Hi Rohit,

 

PFB screenshot for the ls -lrth /bartbkp/bart-2.4/proddb  output

 

bartshowbackups.png

EDB Team Member

Re: EDB BART show backup issue

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. 

Level 3 Adventurer

Re: EDB BART show backup issue

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

 

Regards,

Vijay P Bhat