Restore the Data Store from a backup:
Before You Begin
l
If you updated the dbadmin password using the setup-sw-datastore-
secure-connectivity script, you must also update the password stored in
the pw.ini backup password file, or your restore fails. See Update the Data
Store dbadmin and readonlyuser passwords after initialization for more
information.
l
Identify the Data Node on which you stored the config.ini backup
configuration file, and log into its console as root.
Procedure
1.
Enter su - dbadmin and press Enter to run the following commands as the
dbadmin user.
2.
From the command prompt, enter vbr --task restore --config-file
config-file.ini and press Enter to restore the Data Store from the backup
host.
Start the Data Store:
Before You Begin
l
Log into a Data Node console as root.
Procedure
1.
Enter su - dbadmin and press Enter to run the following commands as the
dbadmin user.
2.
From the command prompt, enter /opt/vertica/bin/admintools -t
start_db -d sw and press Enter to start the Data Store.
What to Do Next
l Remove the catalog snapshot, as described in the next section.
Remove the catalog snapshot:
After you restart the Data Store, remove the snapshot named catalog. This snapshot
is not required after the restore resolves, and prevents Vertica from running retention
management.
© 2021 Cisco Systems, Inc. and/or its affiliates. All rights reserved. - 49 -
Data Store Maintenance