The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Getting Help with Command-Line Tools
![[Deleted User]](https://us.v-cdn.net/6029397/uploads/defaultavatar/nD0LWW9MQTB29.jpg)
Jim Knicely authored this post.
Vertica comes with some nifty command-line tools like vsql, admintools, and vbr. If you need assistance using any of these, you can run them with the –-help parameter to view the options available for each tool.
Example:
[dbadmin@s18384357 ~]$ /opt/vertica/bin/vbr --help vertica backup and restore script help -h --help print help message -t --task { backup | restore | copycluster | replicate | listbackup | init | quick-check | full-check | quick-repair | collect-garbage | remove | 7.2_upgrade } specify task -c --config-file mybackup.conf specify config file --debug { 0 | 1 | 2 | 3 } change output message level --nodes v_mydb_node0001[,...] only operate on nodes inside the comma separated list --showconfig displays parameters in the config file --archive < yymmdd_hhmmss > only valid with --task restore, specify which archive to restore from, and --task remove, specify which archive(s) to remove --dry-run only valid with --task backup/restore/copycluster/replicate, check what the vbr task is going to do, before actually doing --json only valid with --task listbackup, output json format on screen --list-all only valid with --task listbackup, let listbackup list all snapshots on backup hosts --list-output-file only valid with --task listbackup, specify the file to output --old-config-file 7_1backup.conf only valid with 7.2_upgrade, specify old (pre-7.2) config --report-file only valid with --task full-check, specify the file to output, output content is lists of files --restore-objects obj[,...] only valid with --task restore, specify which objects to restore --include-objects pattern[,...] only valid with --task restore, specify object wildcards to include objects for restore --exclude-objects pattern[,...] only valid with --task restore, specify object wildcards to exclude objects from restore --s3-force-init only valid with --task init, force to reinitialize S3 backup locations
Have fun!
0