How to check from which Veritca version a backup was created
Hi Experts,
How can check from which Veritca version a backup was created. I would like to prevent the user from attempting to restore backups that do not match the current Vertica version. By the way, why the version is not listed in vbr.py --task listbackup output?
Best Answer
-
Nimmi_gupta - Select Field - Employee
listbackup does check the version (Vertica version V9.3)
Ex:)
[dbadmin]$ vbr -t listbackup -c full_backup_test_db.ini
backup backup_type epoch objects include_patterns exclude_patterns nodes(hosts) version file_system_type
backup_snapshot_20191107_155012 full 134793 v_test_db_node0001(10.50.50.144), v_test_db_node0002(10.50.50.145), v_test_db_node0003(10.50.50.146), v_test_db_node0004(unknown) v9.3.0-1 [Linux]
backup_snapshot_20191107_121617 full 134770 v_test_db_node0001(10.50.50.144), v_test_db_node0002(10.50.50.145), v_test_db_node0003(10.50.50.146), v_test_db_node0004(unknown) v9.3.0-1 [Linux]
backup_snapshot_20190322_200522 full 35221 v_catalog_test_node0002(10.50.50.145), v_catalog_test_node0003(unknown), v_catalog_test_node0004(10.50.50.147), v_catalog_test_node0005(unknown) v9.1.1-0 [Linux]5