stop_node [options]
|
-h, --help show this help message and exit
-s HOSTS, --hosts=HOSTS
comma-separated list of hosts on which the vertica
process is to be killed using a SIGTERM signal
--compat21 Use Vertica 2.1 method using node names instead of
hostnames
|
host_to_node [options]
|
-h, --help show this help message and exit
-s HOST, --host=HOST comma separated list of hostnames which is to be
converted into its corresponding nodenames
-d DB, --database=DB show only node/host mapping for this database.
|
install_procedure [options]
|
-h, --help show this help message and exit
-d DBNAME, --database=DBNAME
Name of database for installed procedure
-f PROCPATH, --file=PROCPATH
Path of procedure file to install
-p OWNERPASSWORD, --password=OWNERPASSWORD
Password of procedure file onwer
|
return_epoch [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database
|
stop_db [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database to be stopped
-p DBPASSWORD, --password=DBPASSWORD
Database password in single quotes
-F, --force Force the databases to shutdown, even if users are
connected.
-i, --noprompts do not stop and wait for user input(default false)
|
db_remove_node [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database to be modified
-s HOSTS, --hosts=HOSTS
Name of the host to remove from the db
-p DBPASSWORD, --password=DBPASSWORD
Database password in single quotes
-i, --noprompts do not stop and wait for user input(default false)
--compat21 Use Vertica 2.1 method using node names instead of hostnames
|
stop_host [options]
|
-h, --help show this help message and exit
-s HOSTS, --hosts=HOSTS
comma-separated list of hosts on which the vertica
process is to be killed using a SIGTERM signal
--compat21 Use Vertica 2.1 method using node names instead of
hostnames
|
install_node [options]
|
-h, --help show this help message and exit
-s HOSTNAME, --host=HOSTNAME
Comma separated list of hostnames upon which to
install
-r RPMNAME, --rpm=RPMNAME
Fully qualified file name of the RPM to be used on
install
-p PASSWORD, --password=PASSWORD
Name of file containing root password for machines in
the list
--compat21 Use Vertica 2.1 method using node names instead of
hostnames
|
list_allnodes [options]
|
-h, --help show this help message and exit
|
rebalance_data [options]
|
-h, --help show this help message and exit
-d DBNAME, --dbname=DBNAME
database name
-k KSAFETY, --ksafety=KSAFETY
specify the new k value to use
-p PASSWORD, --password=PASSWORD
--script Don't re-balance the data, just provide a script for
later use.
|
logrotate [options]
|
-h, --help show this help message and exit
-d DBNAME, --dbname=DBNAME
database name
-r ROTATION, --rotation=ROTATION
set how often the log is rotated.[
daily|weekly|monthly ]
-s MAXLOGSZ, --maxsize=MAXLOGSZ
set maximum log size before rotation is forced.
-k KEEP, --keep=KEEP set # of old logs to keep
|
drop_db [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Database to be dropped
|
kill_node [options]
|
-h, --help show this help message and exit
-s HOSTS, --hosts=HOSTS
comma-separated list of hosts on which the vertica
process is to be killed using a SIGKILL signal
--compat21 Use Vertica 2.1 method using node names
instead of
hostnames
|
list_db [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database to be listed
|
kill_host [options]
|
-h, --help show this help message and exit
-s HOSTS, --hosts=HOSTS
comma-separated list of hosts on which the vertica
process is to be killed using a SIGKILL signal
--compat21 Use Vertica 2.1 method using node names
instead of
hostnames
|
show_active_db [options]
|
-h, --help show this help message and exit
|
set_restart_policy [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database for which to set policy
-p POLICY, --policy=POLICY
Restart policy: ('never', 'ksafe', 'always')
|
config_nodes [options]
|
-h, --help show this help message and exit
-f NODEHOSTFILE, --file=NODEHOSTFILE
File containing list of nodes, hostnames, catalog
path, and datapath (node<whitespacehost<whitespaceca
talogPath<whitespacedataPath one per line)
-i, --install Attempt to install from RPM on all nodes in the list
-r RPMNAME, --rpm=RPMNAME
Fully qualified file name of the RPM to be used on
install
-p PASSWORD, --password=PASSWORD
Name of file containing Root password for machines in
the list
-c, --check Check all nodes to make sure they can interconnect
-s SKIPANALYZENODE, --skipanalyzenode=SKIPANALYZENODE
skipanalyzenode
|
db_status [options]
|
-h, --help show this help message and exit
-s STATUS, --status=STATUS
Database status UP,DOWN or ALL(list running dbs -
UP,list down dbs - DOWN list all dbs - ALL
|
drop_node [options]
|
-h, --help show this help message and exit
-n NODENAME, --node=NODENAME
Name of the node to be dropped
--force Force a node to be dropped if it? the last reference
to the host.
|
restart_db [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database to be restarted
-e EPOCH, --epoch=EPOCH
Epoch at which the database is to be restarted. If
'last' is given as argument the db is restarted from
the last good epoch.
-p DBPASSWORD, --password=DBPASSWORD
Database password in single quotes
-i, --noprompts do not stop and wait for user input(default false)
|
database_parameters [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database
-P PARAMETER, --parameter=PARAMETER
Database parameter
-c COMPONENT, --component=COMPONENT
Component[optional]
-s SUBCOMPONENT, --subcomponent=SUBCOMPONENT
Sub Component[optional]
-p PASSWORD, --password=PASSWORD
Database password[optional]
|
restart_node [options]
|
-h, --help show this help message and exit
-s NODES, --hosts=NODES
comma-separated list of hosts to be restarted
-d DB, --database=DB Name of database whose node is to be restarted
-p DBPASSWORD, --password=DBPASSWORD
Database password in single quotes
-i, --noprompts do not stop and wait for user input(default false)
--compat21 Use Vertica 2.1 method using node names instead of
hostnames
|
check_spread [options]
|
-h, --help show this help message and exit
|
view_cluster [options]
|
-h, --help show this help message and exit
-x, --xpand show the full cluster state, node by node
-d DB, --database=DB filter the output for a single database
|
node_map [options]
|
-h, --help show this help message and exit
-d DB, --database=DB List only data for this database.
|
list_host [options]
|
-h, --help show this help message and exit
|
start_db [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database to be started
-p DBPASSWORD, --password=DBPASSWORD
Database password in single quotes
-i, --noprompts do not stop and wait for user
input(default false)
|
upgrade_license_key [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database [required if databases exist]
-l LICENSE, --license=LICENSE
Database license
-i INSTALL, --install=INSTALL
argument '-i install' to Install license else without
'-i install' Upgrade license
-p PASSWORD, --password=PASSWORD
Database password[optional]
|
edit_auth [options]
|
-h, --help show this help message and exit
-d DATABASE, --database=DATABASE
database to edit authentication parameters for
|
command_host [options]
|
-h, --help show this help message and exit
-c CMD, --command=CMD
Command to run
|
uninstall_node [options]
|
-h, --help show this help message and exit
-s HOSTNAME, --host=HOSTNAME
Comma separated list of hostnames upon which to
uninstall
-p PASSWORD, --password=PASSWORD
Name of file containing root password for machines in
the list
-d, --delete Delete configuration data during uninstall
--compat21 Use Vertica 2.1 method using node names instead of
hostnames
|
create_db [options]
|
-h, --help show this help message and exit
-s NODES, --hosts=NODES
comma-separated list of hosts to participate in
database
-d DB, --database=DB Name of database to be created
-c CATALOG, --catalog_path=CATALOG
Path of catalog directory[optional] if not using
compat21
-D DATA, --data_path=DATA
Path of data directory[optional] if not using compat21
-p DBPASSWORD, --password=DBPASSWORD
Database password in single quotes [optional]
-l LICENSEFILE, --license=LICENSEFILE
Database license [optional]
-P POLICY, --policy=POLICY
Database restart policy [optional]
--compat21 Use Vertica 2.1 method using node names instead of
hostnames
|
connect_db [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database to connect
-p DBPASSWORD, --password=DBPASSWORD
Database password in single quotes
|
list_node [options]
|
-h, --help show this help message and exit
-n NODENAME, --node=NODENAME
Name of the node to be listed
|
db_replace_node [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database to be restarted
-o ORIGINAL, --original=ORIGINAL
Name of host you wish to replace
-n NEWHOST, --new=NEWHOST
Name of the replacement host
-p DBPASSWORD, --password=DBPASSWORD
Database password in single quotes
-i, --noprompts do not stop and wait for user input(default false)
|
db_add_node [options]
|
-h, --help show this help message and exit
-d DB, --database=DB Name of database to be restarted
-s HOSTS, --hosts=HOSTS
Comma separated list of hosts to add to database
-p DBPASSWORD, --password=DBPASSWORD
Database password in single quotes
-a AHOSTS, --add=AHOSTS
Comma separated list of hosts to add to database
-i, --noprompts do not stop and wait for user input(default false)
--compat21 Use Vertica 2.1 method using node names instead of
hostnames
|
