Upgrade Steps from Vertica 6.0.0 to 6.0.0-3
Posted: Fri Jul 20, 2012 8:50 pm
FYI...
Here are the steps I used to upgrade a test Vertica cluster from 6.0.0 to 6.0.0-3:
1. STOP VERTICA DATABASE via admintools (Login in as db admin user)
2. STOP SPREAD SOFTWARE ON ALL NODES (using command /etc/init.d/spread stop) (Login in as db admin user)
3. Uninstall current Vertica RPM (Login in as root user)
7. Verify your database version in vsql:
Here are the steps I used to upgrade a test Vertica cluster from 6.0.0 to 6.0.0-3:
1. STOP VERTICA DATABASE via admintools (Login in as db admin user)
2. STOP SPREAD SOFTWARE ON ALL NODES (using command /etc/init.d/spread stop) (Login in as db admin user)
3. Uninstall current Vertica RPM (Login in as root user)
- 3.a First find out which Vertic RPMs are installed:
3.b Uninstall the RPMs:Code: Select all
[root@verticatst01 vertica6.0.3]# rpm -qa | grep -i vertica VerticaIPVSLoadBalancer-4.0-0.RHEL5 vertica-6.0.0-0
Code: Select all
[root@verticatst01 vertica6.0.3]# rpm -e VerticaIPVSLoadBalancer-4.0-0.RHEL5.x86_64 [root@verticatst01 vertica6.0.3]# rpm -e vertica-6.0.0-0 Shutting down vertica agent daemon Stopping vertica agent: /etc/rc.d/init.d/vertica_agent: line 111: kill: (-2063) - No such process Deleting spread daemon Deleting spread logrotate configuration Deleting vertica autorestart support Deleting vertica agent support
Code: Select all
[root@verticatst01 vertica6.0.3]# rpm -ivh vertica-6.0.0-3.x86_64.RHEL5.rpm Preparing... ########################################### [100%] 1:vertica ########################################### [100%] Vertica Analytic Database V6.0.0-3 successfully installed on host verticatst01.xxxx.org ---------------------------------------------------------------------------------- Important Information ---------------------------------------------------------------------------------- If you are upgrading from a previous version, you must backup your database before continuing with this install. After restarting your database, you will be unable to revert to a previous version of the software. ---------------------------------------------------------------------------------- To download the latest Vertica documentation in zip or tar format please visit the myvertica web site. To complete installation and configuration of the cluster, run: /opt/vertica/sbin/install_vertica
Code: Select all
[root@verticatst01 vertica6.0.3]# /opt/vertica/sbin/install_vertica -s 10.255.XX.XX1,10.255.XX.XX2,10.255.XX.XX3 -r vertica-6.0.0-3.x86_64.RHEL5.rpm -l /usr/home/dbadmin -u dbadmin Vertica Analytic Database 6.0.0-3 Installation Tool Starting installation tasks... Getting system information for cluster (this may take a while).... Enter password for root@10.255.XX.XX2 (2 attempts left): Installing rpm on 2 hosts.... installing node.... 10.255.XX.XX2 installing node.... 10.255.XX.XX3 Info: the package 'pstack' is useful during troubleshooting. Vertica recommends this package is installed. Checking/fixing OS parameters..... Setting vm.min_free_kbytes to 4096 ... Creating/Checking Vertica DBA group Creating/Checking Vertica DBA user Installing/Repairing SSH keys for dbadmin Modifying existing Vertica DBA user Creating Vertica Data Directory... Testing N-way network test. (this may take a while) All hosts are available ... Verifying system requirements on cluster. IP configuration ... IP configuration ... IP configuration ... Testing hosts (2 of 3).... Running Consistency Tests LANG and TZ environment variables ... Running Network Connectivity and Throughput Tests... Waiting for 1 of 3 sites... ... Consistency Test (ok) ========================= Info: The $TZ environment variable is not set on 10.255.XX.XX1 Info: The $TZ environment variable is not set on 10.255.XX.XX2 Info: The $TZ environment variable is not set on 10.255.XX.XX3 Updating spread configuration... Verifying spread configuration on whole cluster. Error Monitor 0 errors 1 warnings Installation completed with warnings. Installation complete. To create a database: 1. Logout and login as dbadmin.** 2. Run /opt/vertica/bin/adminTools as dbadmin 3. Select Create Database from the Configuration Menu ** The installation modified the group privileges for dbadmin. If you used sudo to install vertica as dbadmin, you will need to logout and login again before the privileges are applied.
7. Verify your database version in vsql:
Code: Select all
bash-3.2$ vsql Welcome to vsql, the Vertica Analytic Database interactive terminal. Type: \h for help with SQL commands \? for help with vsql commands \g or terminate with semicolon to execute query \q to quit dbadmin=> select version(); version ------------------------------------ Vertica Analytic Database v6.0.0-3 (1 row)