Description:
Situations can arise when you must stop and restart the data repository. For example, the computer where the data repository is installed can lose power or can lock up. Or, you want to relocate the computer. In this case, stop and restart the data repository. If you want to install an operating system patch or you want to upgrade to a new version of the data repository, stop and restart the data repository.
Solution:
Follow these steps:
Log in to the computer where Data Aggregator is installed. Log in as the root user or a sudo user with access to a limited set of commands.
Note: For more information about the sudo user, see the Data Aggregator Installation Guide.
Open a command prompt and type the following command:
/etc/init.d/dadaemon stop
Log in to the database server you use for the data repository as the database administrator user, not as the root user.
Type the following command:
/opt/vertica/bin/adminTools
The Administration Tools dialog opens.
Select (4) Stop Database.
Press the Space bar next to the database name, select OK, and press Enter.
You are prompted for the database password.
Enter the database password and press Enter.
The data repository database stops.
Note: If the data repository does not stop, select (2) Stop Vertica on Host from the (7) Advanced Tools Menu.
Select Exit and press Enter.
Relocate the computer, or perform any other administrative tasks.
Log in to the database server you use for the data repository as the database administrator user, not as the root user.
Type the following commands:
/opt/vertica/bin/adminTools
The Administration Tools dialog opens.
Select (3) Start Database.
Press the Space bar next to the database name, select OK, and press Enter.
You are prompted for the database password.
Enter the database password and press Enter.
The data repository database starts.
Select (E) Exit and press Enter.
Start Data Aggregator by logging in to the computer where Data Aggregator is installed. Log in as the root user or a sudo user with access to a limited set of commands.
If you installed Data Aggregator as the sudo user, you set up a sudo command alias for the /etc/init.d/dadaemon command. Use the sudo command to run the dadaemon start script.
Note: For more information about the sudo user, see the Data Aggregator Installation Guide.
Open a command prompt and typing the following command:
/etc/init.d/dadaemon start
The data repository restarts.