I need to upgrade my Vertica version from 6.0 to 7.1. I have 3 nodes cluster on AWS. What is the best way to perform this upgrade ? I have gone through few documents and figure it out that I will have to create a new instance on AWS with 3 nodes with the new supported instances and then install vertica 7.1 and then move the data from older cluster to new. Can't we upgrade directly on the existing cluster?
I can't go for copycluster while doing the data movement because of certain limitations (we have encrypted data).
So we will have to go for EXPORT/COPY FROM utility of Vertica.
Any suggestion is highly appreciated!!