Upgrade Steps from Vertica 6.0.0 to 6.0.0-3

Forum to discuss the Vertica upgrade process

Moderator: norbertk

Upgrade Steps from Vertica 6.0.0 to 6.0.0-3

Postby knicely87 » 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)

    3.a First find out which Vertic RPMs are installed:

    Code: Select all
    [root@verticatst01 vertica6.0.3]# rpm -qa | grep -i vertica
    VerticaIPVSLoadBalancer-4.0-0.RHEL5
    vertica-6.0.0-0

    3.b Uninstall the RPMs:

    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

4. Install new Vertica RPM (Login in as root user)

    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

5. Run install script from the directory containing the downloaded RPM. (Note: use your IP address or host names) (Login in as root user)

    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.

6. Start the database via admintools. (For some reason it asked me to accept a License & Terms agreement) (Login in as db admin user)
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)

ALL DONE! :D
Jim Knicely
HP ATP - Vertica Big Data Solutions V1 Certified

Image
User avatar
knicely87
Site Admin
Site Admin
 
Posts: 1276
Joined: Sat Jan 21, 2012 4:58 am

Sponsored Links

Advertisements

Advertisements
 

Re: Upgrade Steps from Vertica 6.0.0 to 6.0.0-3

Postby khine » Fri May 03, 2013 10:17 am

Hi ,
Can you tell me how can i uninstall vertica ? Actually i want to upgrade CE to EE and i am afraid i might uninstall wroungly.Please kindly help me .

Thanks
khine
Beginner
Beginner
 
Posts: 33
Joined: Wed Apr 03, 2013 2:54 am

Re: Upgrade Steps from Vertica 6.0.0 to 6.0.0-3

Postby sKwa » Fri May 03, 2013 6:44 pm

Hi khine!

Don't worry - just uninstall (before do a backup for /opt/vertica/config folder for any case) exactly as Jim shows.
I did it many times and didn't get any problem.
I'm not a computer expert - if you take anything I write as a suggestion then: DO NOT come to me crying it is my fault that YOU ruined your system!
sKwa
GURU
GURU
 
Posts: 782
Joined: Mon Apr 16, 2012 2:44 pm

Re: Upgrade Steps from Vertica 6.0.0 to 6.0.0-3

Postby khine » Mon May 06, 2013 7:17 am

Hi
i am very curious about the user interface !!! After i install evluation edition it is the user interface is same to community edition ? After i watch demo of vertica on youtube by Mingsheng , i am really wondering how can i get same user interface as what he shown ? Below is the link of demo .

https://www.youtube.com/watch?v=T8AKS77qvNQ


Thanks
khine
Beginner
Beginner
 
Posts: 33
Joined: Wed Apr 03, 2013 2:54 am


Return to Vertica Upgrade

Who is online

Users browsing this forum: No registered users and 1 guest