Vertica upgrade from v5.0.8 to v6.1

Moderator: NorbertKrupa

askh01
Newbie
Newbie
Posts: 11
Joined: Fri Jan 25, 2013 10:08 pm

Vertica upgrade from v5.0.8 to v6.1

Post by askh01 » Wed Mar 06, 2013 9:20 pm

Hi,

We're planning to upgrade our DBs from v5.0.8 to v6.1. We know the path we need to follow:

vertica 5.0 to 6.0
then vertica 6.0 to 6.1

Do you have complete set of instructions or commands to perform this upgrade? Any help will be appreciated.

Thanks,
ASK

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

Re: Vertica upgrade from v5.0.8 to v6.1

Post by JimKnicely » Wed Mar 06, 2013 9:29 pm

Jim Knicely

Image

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

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

Re: Vertica upgrade from v5.0.8 to v6.1

Post by JimKnicely » Wed Mar 06, 2013 9:32 pm

Here is some important info. from the 6.1.1 installation guide:

Upgrading Vertica to a new version

The process of upgrading Vertica is similar to installing it. Upgrades must follow a particular path:
  •  Vertica 3.5 to 4.0
     Vertica 4.0 to 4.1
     Vertica 4.1 to 5.0
     Vertica 4.1 to 5.1
     Vertica 5.0 to 5.1
    Vertica 5.0 to 6.0
     Vertica 5.1 to 6.0
    Vertica 6.0 to 6.1
IMPORTANT NOTE: Vertica strongly recommends that you follow the upgrade paths. Be sure to read the New Features and New Features for each version you skip. The Vertica documentation is available in the rpm, as well as on the myVertica portal http://my.vertica.com/ (which also provides access to previous versions of the documentation).

Important! When upgrading from 5.x to 6.0, due to a change in how transaction catalog storage works in Vertica 6.0 and later, the amount of space that the transaction catalog takes up can increase significantly during and after the upgrade. Verify that you have a at least 4x the size of the Catalog folder in the catalog free (in addition to normal free space requirements) on your nodes prior to upgrading. To determine the amount of space the Catalog folder is using, run du -h on the Catalog folder.

Note: do not run du -h on the entire catalog. Run it specifically on the Catalog folder in the catalog.

For example:

Code: Select all

[dbadmin@localhost ~]$ du -h /home/dbadmin/db/v_db_node0001_catalog/Catalog/
Jim Knicely

Image

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

askh01
Newbie
Newbie
Posts: 11
Joined: Fri Jan 25, 2013 10:08 pm

Re: Vertica upgrade from v5.0.8 to v6.1

Post by askh01 » Fri Mar 08, 2013 6:07 pm

Hi,

Another question is where to download Vertica 6.0 and 6.1 rpms. I downloaded from my.vertica.com and it seems I downloaded the clients i.e.
vertica-client-6.0.1-0.x86_64.rpm and vertica-client-6.1.0-0.x86_64.rpm? I couldn't find vertica-6.0.x86_64.rpm and vertica-6.1.x86_64.rpm. Please advice.


Thanks,

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

Re: Vertica upgrade from v5.0.8 to v6.1

Post by JimKnicely » Fri Mar 08, 2013 9:10 pm

Hi!

On Vertica's website, look in the "Download HP Vertica X.X.X Analytic Database Server" sections ... at the top above the client package section!

For instance, here is a screen shot for 6.0.1:
Attachments
DL1.jpg
DL1.jpg (62.37 KiB) Viewed 4453 times
Jim Knicely

Image

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

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

Re: Vertica upgrade from v5.0.8 to v6.1

Post by id10t » Fri Mar 08, 2013 10:05 pm

Hi!

>> Another question is where to download Vertica 6.0 and 6.1 rpms.
version x.x.x-x
Third number in version is a patch, i.e. 6.0.1 == 6.0, but with patch.
Fourth number - is minor fix, fix in test, temporary fix.

askh01
Newbie
Newbie
Posts: 11
Joined: Fri Jan 25, 2013 10:08 pm

Re: Vertica upgrade from v5.0.8 to v6.1

Post by askh01 » Mon Mar 11, 2013 9:11 pm

Hi,

Thanks for providing me the screen shot. I'm able to download and upgrade Vertica DB from 5.0=>6.0=>6.1 now. The issue is I'm getting the following error message while installing
vertica-client-6.1.0-0.x86_64.rpm on top of vertica-6.1.1-0.x86_64.RHEL5.rpm.

Does it mean one can not install Client on top of vertica-6.1.1-0.x86_64.RHEL5.rpm? Otherwise, please let me know the solutions.
# rpm -qa|grep -i vertica
vertica-6.1.1-0

# rpm -ivh vertica-client-6.1.0-0.x86_64.rpm

Preparing... ########################################### [100%]
file /opt/vertica/bin/vsql from install of vertica-client-6.1.0-0.x86_64 conflicts with file from package vertica-6.1.1-0.x86_64
file /opt/vertica/include/verticaodbc.h from install of vertica-client-6.1.0-0.x86_64 conflicts with file from package vertica-6.1.1-0.x86_64
file /opt/vertica/java/lib/vertica-jdk5.jar from install of vertica-client-6.1.0-0.x86_64 conflicts with file from package vertica-6.1.1-0.x86_64
file /opt/vertica/lib/libverticaodbc.so from install of vertica-client-6.1.0-0.x86_64 conflicts with file from package vertica-6.1.1-0.x86_64


Thanks,
MAK

Post Reply

Return to “Vertica Upgrade”