Pivotal Knowledge Base

Follow

Tips for upgrading GPText

Upgrade Path:

GPText can NOT be upgraded from 1.0.0.0 to 1.1.x.x, so that we need to delete and re-install latest version of GPText binary and recreate all GPText indexes from scratch.

GPText can be upgraded from 1.1.x.x to 1.2.0.0, and then 1.2.0.0 to 1.2.2.0.

How to:
Take upgrading from 1.1.0.1 to 1.2.0.0 for example.
Here are 2 scenarios:

1.  New binary(1.2.0.0) is not installed before upgrading.

Make sure current GPText 1.1.0.x is running well.
gptext-state

Copy the GPText 1.2.0.0 binary to /usr/local, and chmod 755 using root user.
[root@mdw local]# chmod 755 greenplum-text-1.2.0.0-rhel5_x86_64.bin

su to gpadmin user and source the GPText 1.1.0.x env.
[root@mdw local]# su - gpadmin
[gpadmin@mdw ~]$ source /usr/local/greenplum-text-1.1.0.1/greenplum-text_path.sh

Install&Upgrade to GPText 1.2.0.0.
[gpadmin@mdw local]$ bash greenplum-text-1.2.0.0-rhel5_x86_64.bin
Do you want to run upgrade now? [yes|no] yes

Change env to GPText 1.2.0.0 in bash profile.(eg,.bash_rc)
[gpadmin@mdw local]$ source /usr/local/greenplum-text-1.2.0.0/greenplum-text_path.sh
[gpadmin@mdw local]$ gptext-state

2.  New binary is installed already before upgrading.

Following above example, assume that we have already installed GPText 1.2.0.0 binary without upgrading.
[gpadmin@mdw local]$ bash greenplum-text-1.2.0.0-rhel5_x86_64.bin
Do you want to run upgrade now? [yes|no] no

Under old GPText env(1.1.0.x), run gptext-migrator script in GPText 1.2.0.0 binary.
source /usr/local/greenplum-text-1.1.0.1/greenplum-text_path.sh
[gpadmin@mdw ~]$ /usr/local/greenplum-text-1.2.0.0/bin/gptext-migrator -f /usr/local/greenplum-text-1.2.0.0/share/upgrade.yaml

Finally change environment variables to GPText 1.2.0.0 in bash profile.(eg,.bash_rc)

Troubleshooting:

If any errors shows during upgrade, we could use the 2nd way to separate the installation part with upgrade part. So that we can use "-v" option of gptext-migrator to print more debug information.

There are many steps involved during upgrade, below yaml file contains what each step does:
/usr/local/greenplum-text-1.2.0.0/share/upgrade.yaml



Comments

Powered by Zendesk