Upgrade Steps from Vertica 6.0.0 to 6.0.0-3

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Upgrade Steps from Vertica 6.0.0 to 6.0.0-3

Post by JimKnicely » 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

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

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

Post by 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

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Upgrade Steps from Vertica 6.0.0 to 6.0.0-3

Post by id10t » 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.

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

Post by 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

Post Reply

Return to “Vertica Upgrade”