Skip to main content
Question

How to check from which Veritca version a backup was created

  • September 24, 2019
  • 1 reply
  • 5 views

avi120
Forum|alt.badge.img+1
  • Participating Frequently

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?

1 reply

Nimmi_gupta
Forum|alt.badge.img
  • Participating Frequently
  • November 8, 2019

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]