Auto detection of nodes by vbr.py

Moderator: NorbertKrupa

Post Reply
sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

Auto detection of nodes by vbr.py

Post by sarah » Wed Dec 19, 2012 7:52 pm

Hello,

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.
I see in the docs it says:
The utility detects the Vertica node names in the cluster, so you do not have to supply them
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.

Thank you.
Have a GREAT day!

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Auto detection of nodes by vbr.py

Post by JimKnicely » Thu Jan 24, 2013 9:06 pm

Hi,

I think that the set up goes out and grabs the first database returned from the /opt/vertica/bin/admintools -t db_status -s ALL command which is kind of silly. You must have the ClickStreamDB example database installed. If you aren't using it, you can drop it. Other wise, try specifying the nodes with the --nodes swtich of the vbr.py command. Like this:

Code: Select all

vbr.py --setupconfig --nodes v_xxx_node0001,v_xxx_node0002,v_xxx_node0003
Let us know how this works out please :)
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

Re: Auto detection of nodes by vbr.py

Post by sarah » Mon Jan 28, 2013 2:03 pm

knicely87, you were correct. I dropped the clickstreamdb database then re-ran the vbr setup utility and it correctly identified the nodes used by the database with the objects I want to back up.

Weird. I wonder why the set up doesn't just ask which database we want to backup?!?! :roll:
Have a GREAT day!

Post Reply

Return to “Vertica Backup & Recovery”