Vertica upgrade from v5.0.8 to v6.1

[askh01]

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

[JimKnicely]

Check out these posts:

viewtopic.php?f=15&t=94
viewtopic.php?f=11&t=385
viewtopic.php?f=15&t=662&p=2185
viewtopic.php?f=15&t=320

Upgrading Vertica is really easy!

[JimKnicely]

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/

[askh01]

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,

[JimKnicely]

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:

[id10t]

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]

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