Starting the Database
To start your Vertica database, add a command to your packaging script that uses the admintools
script with either the start_db
or restart_db
option:
- The
start_db
option starts a database/ - The
restart_db
option allows you to restart the database at the last good epoch, minimizing any loss of data.
start_db Option
$ /opt/vertica/bin/admintools --tool start_db [ options ]
Command-Line Options
Option | Purpose |
---|---|
-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 .) |
The following example starts the database called VMart and assigns the database password Vertica1:
$ admintools -t start_db -d VMart -p Vertica1
restart_db Option
$ /opt/vertica/bin/admintools --tool restart_db [ options ]
Command-Line Options
Option | Purpose |
---|---|
-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 |
-p DBPASSWORD --password=DBPASSWORD |
Database password in single quotes. |
-i --noprompts |
Do not stop and wait for user input. (Default: False.) |