System information
Upgrading to Greenplum Database 4.2.x.x 17
Greenplum Database 4.2.7.3 Release Notes
10. (optional but strongly recommended) Back up all databases in your Greenplum
Database system using
gpcrondump
(or zfs snapshots on Solaris systems). See the
Greenplum Database Administrator Guide for more information on how to do
backups using
gpcrondump
. Make sure to secure your backup files in a location
outside of your Greenplum data directories.
11. If your system has a standby master host configured, remove the standby master
from your system configuration. For example:
$ gpinitstandby -r
12. Perform a clean shutdown of your current Greenplum system. For example:
$ gpstop
13. Source the path file from your new 4.2.x.x installation. For example:
$ source /usr/home/greenplum-db-4.2.x.x/greenplum_path.sh
14. Update your environment so it is sourcing your new 4.2.x.x installation.
a. For example, update the
greenplum-db
symbolic link on the master and
standby master to point to the new 4.2.x.x installation directory. For example
(as root):
# rm -rf /usr/local/greenplum-db
# ln -s /usr/local/greenplum-db-4.2.x.x
/usr/local/greenplum-db
# chown -R gpadmin /usr/local/greenplum-db
b. Using gpssh, also update the
greenplum-db
symbolic link on all of your
segment hosts. For example (as root):
# gpssh -f
segment_hosts_file
=> rm -rf /usr/local/greenplum-db
=> ln -s /usr/local/greenplum-db-4.2.x.x
/usr/local/greenplum-db
=> chown -R gpadmin /usr/local/greenplum-db
=> exit
15. (optional but recommended) Prior to running the migration, perform a
pre-upgrade check to verify that your database is healthy by executing the 4.2.x.x
version of the
gpmigrator
utility with the
--check-only
option. For example:
# gpmigrator_mirror --check-only
/usr/local/greenplum-db-4.1.1.5
/usr/local/greenplum-db-4.2.x.x
16. As
gpadmin
, run the 4.2.x.x version of the migration utility specifying your old
and new
GPHOME
locations. If your system has mirrors, use
gpmigrator_mirror
.
If your system does not have mirrors, use
gpmigrator
. For example on a system
with mirrors:
$ su -
gpadmin
$ gpmigrator_mirror /usr/local/greenplum-db-4.1.1.5
/usr/local/greenplum-db-4.2.x.x