DCA System Installation and Upgrade

DCA System Installation and Upgrade

On supported Dell EMC DCA systems, you can install Pivotal Greenplum 6, or you can upgrade from Pivotal Greenplum 6.x to 6.new.

Only Pivotal Greenplum Database is supported on DCA systems. Open source versions of Greenplum Database are not supported.

Important: Upgrading Pivotal Greenplum Database 4 or 5 to Pivotal Greenplum 6 is not supported.

Installing the Pivotal Greenplum 6 Software Binaries on DCA Systems

Important: This section is for installing Pivotal Greenplum 6 only on DCA systems. Also, see the information on the DELL EMC support site (requires login).

Prerequisites

  • Ensure your DCA system supports Pivotal Greenplum 6. See Supported Platforms.
  • Ensure that no previous versions of Greenplum Database are installed on your system.

    Installing Pivotal Greenplum 6 on a DCA system with an existing Greenplum Database installation is not supported. For information about uninstalling Greenplum Database software, see your Dell EMC DCA documentation.

Installing Pivotal Greenplum 6

  1. Download or copy the Greenplum Database DCA installer file to the Greenplum Database master host.
  2. As root, run the DCA installer for Greenplum 6 on the Greenplum Database master host and specify the file hostfile that lists all hosts in the cluster, one host name per line. If necessary, copy hostfile to the directory containing the installer before running the installer.

    This example command runs the installer for Greenplum Database 6.

    # ./greenplum-db-appliance-<version>-RHEL6-x86_64.bin hostfile

Upgrading Greenplum 6.x on DCA Systems

Upgrading Pivotal Greenplum from 6.x to 6.new on a Dell EMC DCA system involves stopping Greenplum Database, updating the Greenplum Database software binaries, and restarting Greenplum Database.

Important: This section is only for upgrading Pivotal Greenplum 6 on DCA systems. For information about upgrading on non-DCA systems, see Upgrading Greenplum Database.
  1. Log in to your Greenplum Database master host as the Greenplum administrative user (gpadmin):
    # su - gpadmin
  2. Download or copy the installer file greenplum-db-appliance-<6.new>-RHEL6-x86_64.bin to the Greenplum Database master host.
  3. Perform a smart shutdown of your existing Greenplum Database 6.x system (there can be no active connections to the database). This example uses the -a option to disable confirmation prompts:
    $ gpstop -a
  4. As root, run the Greenplum Database DCA installer for 6.new on the Greenplum Database master host and specify the file hostfile that lists all hosts in the cluster. If necessary, copy hostfile to the directory containing the installer before running the installer.

    This example command runs the installer for Greenplum Database 6.new for Red Hat Enterprise Linux 6.x.

    # ./greenplum-db-appliance-<6.new>-RHEL6-x86_64.bin hostfile

    The file hostfile is a text file that lists all hosts in the cluster, one host name per line.

  5. If needed, update the greenplum_path.sh file for use with your specific installation. These are some examples.
    • If Greenplum Database uses LDAP authentication, edit the greenplum_path.sh file to add the line:
      export LDAPCONF=/etc/openldap/ldap.conf
    • If Greenplum Database uses PL/Java, you might need to set or update the environment variables JAVA_HOME and LD_LIBRARY_PATH in greenplum_path.sh.
    Note: When comparing the previous and new greenplum_path.sh files, be aware that installing some Greenplum Database extensions also updates the greenplum_path.sh file. The greenplum_path.sh from the previous release might contain updates that were the result of those extensions.
  6. Install Greenplum Database extension packages. For information about installing a Greenplum Database extension package, see gppkg in the Greenplum Database Utility Guide.

    Also migrate any additional files that are used by the extensions (such as JAR files, shared object files, and libraries) from the previous version installation directory to the new version installation directory.

  7. After all segment hosts have been upgraded, you can log in as the gpadmin user and restart your Greenplum Database system:
    # su - gpadmin
    $ gpstart
  8. If you are utilizing Data Domain Boost, you have to re-enter your DD Boost credentials after upgrading to Greenplum Database 6 as follows:
    gpcrondump --ddboost-host ddboost_hostname --ddboost-user ddboost_user
      --ddboost-backupdir backup_directory
    Note: If you do not reenter your login credentials after an upgrade, your backup will never start because the Greenplum Database cannot connect to the Data Domain system. You will receive an error advising you to check your login credentials.

After upgrading Greenplum Database, ensure features work as expected. For example, you should test that backup and restore perform as expected, and Greenplum Database features such as user-defined functions, and extensions such as MADlib and PostGIS perform as expected.