Post Expansion Tasks

After the expansion is completed, you must perform different tasks depending on your environment.

• Removing the Expansion Schema
• Setting Up PXF on the New Host

Parent topic: Expanding a Greenplum System

Removing the Expansion Schema

You must remove the existing expansion schema before you can perform another expansion operation on the Greenplum system.

You can safely remove the expansion schema after the expansion operation is complete and verified. To run another expansion operation on a Greenplum system, first remove the existing expansion schema.

1. Log in on the master host as the user who will be running your Greenplum Database system (for example, gpadmin).

2. Run the gpexpand utility with the -c option. For example:

   $ gpexpand -c
   

   Note

   Some systems require you to press Enter twice.

Setting Up PXF on the New Host

If you are using PXF in your Greenplum Database cluster, you must perform some configuration steps on the new hosts.

There are different steps to follow depending on your PXF version and the type of installation.

PXF 5

• You must install the same version of the PXF rpm or deb on the new hosts.

• Log into the Greenplum Master and run the following commands:

  gpadmin@gpmaster$ pxf cluster reset
  gpadmin@gpmaster$ pxf cluster init
  

PXF 6

• You must install the same version of the PXF rpm or deb on the new hosts.

• Log into the Greenplum Master and run the following commands:

  gpadmin@gpmaster$ pxf cluster register
  gpadmin@gpmaster$ pxf cluster sync