Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
UPGRADE Vertica Community Edition from 6.0.1 to 6.1.2
Hi, I've just followed this procedure to upgrade my Vertica Community Edition from 6.0.1 to 6.1.2. I'd like to know if there is an easier different way. 1. SHUTDOWN DB 2. BACKUP VERTICA DIR: * cd /storage/home/dbadmin * mv vertica vertica_bkup 3. REMOVE OLD RPM AND INSTALL NEW ONE ( community edition 6.1.0 does not exist, so we go directly from 6.0.1 to 6.1.2 because we can't do the standard upgrade : 6.0.1 -> 6.1.0 -> 6.1.2): * rpm -e vertica-ce-6.0.1-0.x86_64 * rpm -ivh /storage/archive_file/vertica-6.1.2-0.x86_64.RHEL5.rpm * /opt/vertica/sbin/install_vertica -l /storage/home/dbadmin/ 4. RESTORE OLD VERTICA DIR: * cd /storage/home/dbadmin/ * mv vertica_bkup vertica 5. START DB after this procedure I find the new Vertica installed with the old data. please notice that I had to reinstall all the external libraries (i.e. strings_package and shell_load_package from vertica_extension_package) I'd like to know if there exist an easier way. thanks, Pietro.