gppkg

    The Greenplum Package Manager (gppkg) utility installs Greenplum Database extensions, along with any dependencies, on all hosts across a cluster. It will also automatically install extensions on new hosts in the case of system expansion and segment recovery.

    Note: After a major upgrade to Greenplum Database, you must download and install all gppkg extensions again.

    Examples of database extensions and packages software that are delivered using the Greenplum Package Manager are:

    • PL/Java
    • PL/R
    • MADlib

    -a (do not prompt)

    Do not prompt the user for confirmation.

    -c | —clean

    Reconciles the package state of the cluster to match the state of the master host. Running this option after a failed or partial install/uninstall ensures that the package installation state is consistent across the cluster.

    -d master_data_directory

    -i package | —install=package

    Installs the given package. This includes any pre/post installation steps and installation of any dependencies.

    --migrate GPHOME_old GPHOME_new

    Migrates packages from a separate $GPHOME. Carries over packages from one version of Greenplum Database to another.

    For example:

    When migrating packages, these requirements must be met.

    • At least the master instance of the destination Greenplum Database must be started (the instance installed in GPHOME_new). Before running the gppkg command start the Greenplum Database master with the command gpstart -m.

    -q | —query query_option

    Provides information specified by query_option about the installed packages. Only one can be specified at a time. The following table lists the possible values for query_option. <package_file> is the name of a package.

    Removes the specified package.

    -u package | —update=package

    Updates the given package.

    Warning: The process of updating a package includes removing all previous versions of the system objects related to the package. For example, previous versions of shared libraries are removed. After the update process, a database function will fail when it is called if the function references a package file that has been removed.

    --version (show utility version)

    Displays the version of this utility.

    -v | —verbose

    Sets the logging level to verbose.

    Displays the online help.