Before You Upgrade

Before you upgrade the Vertica database, you must perform the following steps:

• Perform a full database backup. This precautionary measure allows you to restore the current version if the upgrade is unsuccessful.
• Verify platform requirements for the new version.
• Fix or remove unsupported projections. In all post-9.0 versions of Vertica, support has been removed for projection buddies with different SELECT and ORDER BY clauses. Support also has been removed for pre-join and range segmentation projections. If the upgrade encounters unsupported projections, is liable to fail.
• Check catalog storage space.

After you complete these tasks, shut down the database gracefully.