I'm starting to play around with the backup utility (vbr.py) provided by Vertica and I have a question about setting up the config file. I just want to back up (as a test) the table date_d in the vtest schema.
Here's what I am running:
Code: Select all
sarah-admin$ /opt/vertica/bin/vbr.py --setupconfig
Snapshot name (backup_snapshot): my_test
Backup vertica configurations? (n) [y/n]: n
Number of restore points (1): 1
Specify objects (no default): vtest.date_d
Vertica user name (dbadmin): dbadmin
Save password to avoid runtime prompt? (n) [y/n]: n
Node v_clickstreamdb_node0001
Backup host name (no default): vtst01
Backup directory (no default): /home/dbadmin/backup
Node v_clickstreamdb_node0002
Backup host name (no default): vtst02
Backup directory (no default): /home/dbadmin/backup
Node v_clickstreamdb_node0003
Backup host name (no default): vtst03
Backup directory (no default): /home/dbadmin/backup
Config file name (my_test.ini):
Change advanced settings? (n) [y/n]: n
Saved vbr configuration to my_test.ini.
The question I have is how is the utility getting the node names? As you can see in my output above it picked up the nodes v_clickstreamdb_node0001, v_clickstreamdb_node0002 and v_clickstreamdb_node0003. Those are NOT the node names for the active database.The utility detects the Vertica node names in the cluster, so you do not have to supply them
Thank you.