System information

Upgrading to Greenplum Database 4.2.x.x 19

Greenplum Database 4.2.7.3 Release Notes

Upgrade Checklist

This checklist provides a quick overview of all the steps required for an upgrade from

4.1.x.x to 4.2.x.x. Detailed upgrade instructions are provided in the Upgrade

Procedure section.

Pre-Upgrade Preparation (on your current system)

* 4.1.x.x system is up and available

gpadmin

user (your Greenplum superuser).

(Optional) Run

VACUUM

on all databases,

(Optional) Remove old server log files from

pg_log

in your master and

segment data directories.

Check for and recover any failed segments (

gpstate

gprecoverseg

Copy or preserve any additional folders or files (such as backup folders).

Install the Greenplum Database 4.2.x.x binaries on all Greenplum hosts.

Inform all database users of the upgrade and lockout time frame.

Upgrade Execution

* The system will be locked down to all user activity during the upgrade process

Backup your current databases.

Remove the standby master (

gpinitstandby -r

Do a clean shutdown of your current system (

gpstop

Update your environment to source the new Greenplum Database 4.2.x.x

installation.

Run the upgrade utility (

gpmigrator_mirror

if you have mirrors,

gpmigrator

if you do not).

After the upgrade process finishes successfully, your 4.2.x.x system will be

up and running.

Post-Upgrade (on your 4.2.x.x system)

* The 4.2.x.x system is up

Reinitialize your standby master host (

gpinitstandby