After You Upgrade

After you finish upgrading the Vertica server package on your cluster, a number of tasks remain.

Required Tasks

If you created projections in earlier releases with pre-aggregated data (for example, LAPs and TopK projections) and the projections were partitioned with a GROUP BY clause, you must rebuild these projections.
Verify on each node that the upgrade reduced database catalog memory usage.
Verify your database retained the grants from before you upgraded. See Backing Up and Restoring Grants for more information.
Reinstall packages such as the R language pack that you uninstalled before upgrading. For each package, see its install/upgrade instructions.

Vertica Place is automatically reinstalled with the Vertica server package.
If the upgrade was unable to install one or more packages, reinstall them with admintools.
Upgrade the Management Console.
If your Vertica installation is integrated with Hadoop, upgrade the HCatalog connector.

Import directed queries that you exported from the previous version. For details, see Batch Query Plan Export and Exporting Directed Queries from the Catalog.
If you're upgrading from Vertica 9.2.x and have set the PasswordMinCharChange or PasswordMinLifeTime system-level security parameters, set them again at the PROFILE-level.