Skip to main content
Question

Want to upgrade vertica from 7.0 to 9.3.

  • October 31, 2019
  • 3 replies
  • 18 views

hsaxena20
Forum|alt.badge.img+1

Please tell me the steps and challenges which I can get. Also, there are so many user-defined functions and packages installed. How I can take the backup of user-defined functions.
Please help ASAP.

3 replies

Vertica_Curtis
Forum|alt.badge.img+1
  • Participating Frequently
  • October 31, 2019

One easy way is to just build a new cluster and migrate the data across. If that's not an option, you'll need to follow the upgrade paths: https://www.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/InstallationGuide/Upgrade/UpgradePaths.htm?TocPath=Installing%20Vertica|Upgrading%20Vertica|_____1
You don't actually need to restart the database between each upgrade.
When you say user-defined functions, are these UDxs that you've built using R or Python? The backup should include them, but the code you'll need to store separately. The upgrade process won't remove them.

But that's a lot of upgrades. I'd definitely recommend a backup before you begin. Keep in mind that the recovery process is to delete everything and restoring to a clean 7,0 environment. I've never heard of anyone having to do that, though.


hsaxena20
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 31, 2019

Thanks for the reply. Yes, user-defined functions are in Python.


LenoyJ
Forum|alt.badge.img+1
  • Participating Frequently
  • October 31, 2019