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.
- Installing the Pivotal Greenplum 6 Software Binaries on DCA Systems
- Upgrading Greenplum 6.x on DCA Systems
Installing the Pivotal Greenplum 6 Software Binaries on DCA Systems
- Ensure your DCA system supports Pivotal Greenplum 6. See Supported Platforms.
- Ensure that no previous versions of Greenplum Database are installed on your
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
- Download or copy the Greenplum Database DCA installer file to the Greenplum Database master host.
- 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.
- Log in to your Greenplum Database master host as the Greenplum
administrative user (gpadmin):
# su - gpadmin
- Download or copy the installer file greenplum-db-appliance-<6.new>-RHEL6-x86_64.bin to the Greenplum Database master host.
- 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
$ gpstop -a
- 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.
- If needed, update the greenplum_path.sh file for use with your specific
installation. These are some examples.
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.
- If Greenplum Database uses LDAP authentication, edit the
greenplum_path.sh file to add the
- 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.
- If Greenplum Database uses LDAP authentication, edit the greenplum_path.sh file to add the line:
- 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.
- After all segment hosts have been upgraded, you can log in as the
gpadmin user and restart your Greenplum Database
# su - gpadmin $ gpstart
- If you are utilizing Data Domain Boost, you have to re-enter your DD
Boost credentials after upgrading to Greenplum Database 6 as follows: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.