Before You Upgrade

Vertica 9.3.x and 10.0.x do not support FIPS because of a limitation with OpenSSL. If you need FIPS support, install or upgrade to 10.1.1 or above.

If you install or upgrade from Vertica 9.2.x to Vertica 10.0. on a FIPS-enabled machine, you may encounter the following error: "Upgrading to Vertica 10.0.x-xxxxxxxx on a FIPS system is not supported." To resolve this, you must downgrade to Vertica 9.2.x: uninstall the Vertica RPM on every node in the cluster and then reinstallVertica 9.2.x.

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

  • Verify that you have enough RAM available to run the upgrade. The upgrade requires approximately three times the amount of memory your database catalog uses.

    You can calculate catalog memory usage on all nodes by querying system table RESOURCE_POOL_STATUS:

    => SELECT node_name, pool_name, memory_size_kb FROM resource_pool_status WHERE pool_name = 'metadata';
  • Perform a full database backup. This precautionary measure allows you to restore the current version if the upgrade is unsuccessful.
  • Perform a backup of your grants.
  • Verify platform requirements for the new version.
  • Identify and 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.