Installing Additional Supplied Modules

The Greenplum Database distribution includes several PostgreSQL- and Greenplum-sourced contrib modules that you have the option to install.

Each module is typically packaged as a Greenplum Database extension. You must register these modules in each database in which you want to use it. For example, to register the dblink module in the database named testdb, use the command:

$ psql -d testdb -c 'CREATE EXTENSION dblink;'

To remove a module from a database, drop the associated extension. For example, to remove the dblink module from the testdb database:

$ psql -d testdb -c 'DROP EXTENSION dblink;'

Note

When you drop a module extension from a database, any user-defined function that you created in the database that references functions defined in the module will no longer work. If you created any database objects that use data types defined in the module, Greenplum Database will notify you of these dependencies when you attempt to drop the module extension.

You can register the following modules in this manner:

btree_gin citext dblink diskquota fuzzystrmatch gp_array_agg gp_check_functions gp_parallel_retrieve_cursor gp_percentile_agg gp_sparse_vector greenplum_fdw hstore	ip4r ltree orafce (VMware Greenplum only) pageinspect pg_trgm pgcrypto postgres_fdw postgresql-hll sslinfo tablefunc timestamp9 uuid-ossp

For additional information about the modules supplied with Greenplum Database, refer to Additional Supplied Modules in the Greenplum Database Reference Guide.

Parent topic: Installing and Upgrading Greenplum