Prepare for the Platform Analytics upgrade

Obtain the upgrade package files and upgrade the Vertica database to prepare for the Platform Analytics upgrade.

What you need to do

Check the following:

  • The Vertica database host is properly configured and running.

  • You have a user name, password, and URL to access the database.

    The Platform Analytics database user must have the following:

    • Roles: Connect and resource.

    • System privileges: Create view.

  • The Vertica database and the database host meet the Platform Analytics system requirements.

    Refer to the Release Notes for Platform Platform Analytics for the latest system requirements for the database host.

  1. Obtain the necessary upgrade package files
  2. Update the database schema

Obtain the necessary upgrade package files

Obtain the necessary files for upgrading Platform Analytics.
  • Platform Analytics server upgrade package

    platform_analytics8.0.2_server_upgrade_${OS}.zip

  • Platform Analytics node upgrade package

    platform_analytics8.0.2_node_upgrade_${OS}.zip

  • Platform Analytics database schema upgrade package

    platform_analytics8.0.2_upgrade_dbschema.zip

Update the database schema

Update the Vertica database schema and the data to prepare the database host for the Platform Analytics upgrade.

Note:

The database schema upgrade package does not support upgrading non-partitioned schema to a partitioned schema, and vice versa.

Therefore, if you are using a non-partitioned schema, you cannot upgrade to a partitioned schema using the database schema upgrade package.

Update the database schema in the Vertica database

  1. Log into the Vertica database host.
  2. (Optional) Set VERTICA_ROOT environment variable to the Vertica installation directory. If you have not installed Vertica on the default location, set it to /opt/vertica.
  3. Extract the database schema upgrade package.

    unzip platform_analytics8.0.2_server_upgrade_${OS}.zip

  4. Navigate to the directory containing your database schema scripts.

    migration/schema/Vertica

  5. Run the script upgrade_schema.sh to upgrade the database.

    sh upgrade_schema.sh <user_name> <password> <database_name> <port>

    where
    • user_name is the name of the Platform Analytics database user.

    • password is the password for the database user.

    • database_name is the name of the database.

    • port is the TCP port number or the local socket file extension in which the server is listening for connections. The default port number is 5433