Best type of Vertica backup for 21.2.5 upgrade - hardlink or full? And, what is the best way to validate backups are good without actually restoring?

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

How can we list backups in vertica?

Environment

Dx NetOps Performance Management any version

Resolution

As the dradmin user run the following command:

/opt/vertica/bin/vbr.py --task listbackup --config-file <path to ini file>

 

Results:

backup                            backup_type   epoch      objects   include_patterns   exclude_patterns   nodes(hosts)                                                                                        version    file_system_type
backup_snapshot_20211209_161832   full          15418874                                                   v_drdata_node0001(xx.xxx.xx.xx), v_drdata_node0002(xx.xxx.xx.xx), v_drdata_node0003(xx.xxx.xx.xx)   v9.1.1-5   [Linux]