upgrade steps, please refer to my previous posts [[Installing Vertica 7|here]] and [[Vertica Installation Prereqs|here]] that should fill in the gaps if anything is unclear. If you are not sure what version of Vertica you are running you can run
pscp <location of .deb file> <user>@<ip>:<path on ubuntu>
du -h /home/dbadmin/<db>/<node>_catalog/Catalog.
nano /opt/vertica/config/admintools.conf. Search for "install_opts" which will detail the options you used previously. This is an important step...if you accidentally choose a different set of options when you upgrade then you may find that Vertica stops working due to mismatched components. Note the install_opts for later. You do not need to note the -s or --hosts parameters (more on why later).
/opt/vertica/bin/admintools --tool stop_db -d VMart -p <password>
sudo dpkg -i /home/dbadmin/<file>.deb
update_verticawith the install_opts noted earlier, substituting the new .deb name for the old one. You do not need to pass the --hosts or -s parameters...those are automatically determined by the installer based on the current hosts in the cluster, which may differ from the hosts that existed when you last installed/upgraded Vertica. Here's an example command:
sudo /opt/vertica/sbin/update_vertica --hosts <IPs> --deb /home/<deb file> -L CE -accept-eula
Similar to SQL Server, a database is upgraded when it is first started in Vertica...so expect the initial startup to take a bit longer than normal. Remember, this needs to upgrade the data files and catalog on ALL nodes in your cluster. At this point you may want to verify that you actually DID upgrade your database...note that my db is now reporting 7.0.2-1.
Now would be a good time to take another backup.
If you encounter errors that you feel you can safely skip then you can always use the --failure-threshold option. I recently wrote a blog post on this.
Lastly, you may have to upgrade supporting packages as well, such as MC. Check your documentation.
You have just read "[[Upgrading Vertica]]" on davewentzel.com. If you found this useful please feel free to subscribe to the RSS feed.
Dave Wentzel CONTENT