Upgrading a VMware Greenplum Text system to a new VMware Greenplum Text release installs the new VMware Greenplum Text software release on all hosts in the Greenplum cluster and then upgrades the VMware Greenplum Text system.

Upgrading VMware Greenplum Text and VMware Greenplum at the Same Time

If you are upgrading to new releases of VMware Greenplum and VMware Greenplum Text at the same time, follow these steps:

  1. Complete the VMware Greenplum upgrade first and ensure the database is operational.

  2. Source the greenplum_path.sh file in the new VMware Greenplum installation directory.

  3. Source the greenplum-text_path.sh file in the older VMware Greenplum Text installation directory.

    $ source /usr/local/greenplum-text-<version>/greenplum-text_path.sh
    
  4. Make sure the gpadmin user has write permission in the $GPHOME/lib/postgres directory. The gptext-migrator utility installs the VMware Greenplum Text library into this directory.

  5. Run the VMware Greenplum Text gptext-migrator utility to migrate your current VMware Greenplum Text system to the newly upgraded VMware Greenplum system.

  6. Ensure that the current version of VMware Greenplum Text works with the new VMware Greenplum version.

  7. Proceed with the VMware Greenplum Text upgrade.

Upgrading a VMware Greenplum Text Release

Upgrading a VMware Greenplum Text release is a two-part process: install the new software release on the Greenplum cluster hosts and then upgrade the existing VMware Greenplum Text system. The VMware Greenplum Text installer performs the first part, installing the new software. The gptext-upgrade utility performs the second part, upgrading the current VMware Greenplum Text system to the new version.

The VMware Greenplum Text installer detects an existing VMware Greenplum Text system and, after installing the new software release, offers to run the gptext-upgrade utility for you. If you choose to upgrade the VMware Greenplum Text system later, you can run the gptext-upgrade utility yourself.

All upgrade tasks are executed on the Greenplum master host as the gpadmin user. The gpadmin user must have write permission in the directory where the new VMware Greenplum Text release is to be installed, /usr/local/greenplum-text-<release>-<version> by default.

The VMware Greenplum, ZooKeeper, and VMware Greenplum Text clusters must be running. The procedure stops and restarts VMware Greenplum Text during the upgrade.

Follow these steps:

  1. Download the new VMware Greenplum Text release for your platform from VMware Network.

  2. Extract the release package.

    $ tar xfz greenplum-text-<version>-<platform>.tar.gz
    
  3. Make sure that ZooKeeper and VMware Greenplum Text are running.

    $ gptext-state
    
  4. Run the VMware Greenplum Text installer.

    $ ./greenplum-text-<version>-<platform>.bin
    

    Note: When upgrading VMware Greenplum Text, you do not specify an installation configuration file as you do for the initial VMware Greenplum Text installation.

  5. The installer prompts you to accept the license agreement and to choose and create the installation directory.

  6. The installer verifies the environment to ensure that prerequisites are present, such as Python and Java. If any problems are discovered, the installer outputs an error message and stops. Correct the problem identified by the message and run the installer again.

  7. After the new software has been installed on the Greenplum cluster, the installer looks for an existing VMware Greenplum Text installation. If an existing VMware Greenplum Text system is found, the installer asks if you wish to upgrade VMware Greenplum Text directly.

    • If you answer yes, the installer runs the gptext-upgrade script. The gptext-upgrade utility validates the environment to ensure it can complete the upgrade, then executes the upgrade and restarts the VMware Greenplum Text system. If any problems are discovered, gptext-upgrade outputs a message and quits. Fix the indicated problems and run the gptext-upgrade utility (at <NEW_GPTEXTHOME>/bin/gptext-upgrade) to complete the VMware Greenplum Text system upgrade.
    • If you answer no, you must run the gptext-upgrade script after the installer completes. See the gptext-upgrade utility reference for instructions.

    Important: If you answer no or if the gptext-upgrade quits without upgrading your software, follow these steps to re-run gptext-upgrade at a later time:

    1. Source the greenplum-text_path.sh script in the old VMware Greenplum Text installation directory. For example:
      $ source /usr/local/greenplum-text-<old-version>/greenplum-text_path.sh
    2. Run the gptext-upgrade command from the new VMware Greenplum Text installation directory:
      $ /usr/local/greenplum-text-<new-version>/bin/gptext-upgrade
  8. After the upgrade has completed, source the greenplum-text_path.sh in the new VMware Greenplum Text release directory and run gptext-state healthcheck to verify the VMware Greenplum Text system:

    $ source /usr/local/greenplum-text-<version>/greenplum-text_path.sh
    $ gptext-state healthcheck
    
check-circle-line exclamation-circle-line close-line
Scroll to top icon