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.

    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:

    Note

    In general, it is best to avoid using the --migrate option, and packages should be reinstalled, not migrated. See .

    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

    -r name-version | –remove=name-version

    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.