System information

Upgrading to Greenplum Database 4.2.x.x 13

Greenplum Database 4.2.7.3 Release Notes

Upgrading to Greenplum Database 4.2.x.x

The upgrade path supported for this release is Greenplum Database 4.1.x.x to

Greenplum Database 4.2.x.x. The minimum recommended upgrade path for this

release is from Greenplum Database version 4.1.1.5. If you have an earlier major

version of the database, you must first upgrade to version 4.1.x.

For detailed upgrade procedures and information, see the following sections:

• Upgrading from 4.2.x.x to 4.2.7.3

• Upgrading from 4.1.x.x to 4.2.x.x

• For Users Running Greenplum Database 4.0.x.x

• For Users Running Greenplum Database 3.3.x.x

• Troubleshooting a Failed Upgrade

Upgrading from 4.2.x.x to 4.2.7.3

An upgrade from 4.2.x.x to 4.2.7.3 involves stopping Greenplum Database, updating

the Greenplum Database software binaries, and restarting Greenplum Database.

1. Log in to your Greenplum Database master host as the Greenplum administrative

user:

$ su - gpadmin

2. Perform a smart shutdown of your current Greenplum Database 4.2.x.x system

(there can be no active connections to the database):

$ gpstop

3. Run the installer for 4.2.7.3 on the Greenplum Database master host. When

prompted, choose an installation location in the same base directory as your

current installation. For example:

/usr/local/greenplum-db-4.2.2.x

4. Edit the environment of the Greenplum Database superuser (gpadmin) and make

sure you are sourcing the

greenplum_path.sh

file for the new installation. For

example change the following line in

.bashrc

or your chosen profile file:

source /usr/local/greenplum-db-4.2.x.x/greenplum_path.sh

to:

source /usr/local/greenplum-db-4.2.7.3/greenplum_path.sh

Or if you are sourcing a symbolic link (/usr/local/greenplum-db) in your

profile files, update the link to point to the newly installed version. For example:

$ rm /usr/local/greenplum-db

$ ln -s /usr/local/greenplum-db-4.2.7.3

/usr/local/greenplum-db

5. Source the environment file you just edited. For example:

$ source ~/.bashrc