Skip to content

Installing additional modules

WarehousePG ships with bundled modules that require no extra install, and supports separately provided modules that require a package install on each host before enabling.

Bundled modules

Bundled modules are included in the WarehousePG distribution. Activate them in each database where you want them available:

bash
psql -d <database_name> -c 'CREATE EXTENSION <extension_name>;'

To remove a bundled extension from a database:

bash
psql -d <database_name> -c 'DROP EXTENSION <extension_name>;'

Some bundled modules use shared_preload_libraries instead of CREATE EXTENSION. See the bundled modules reference for details on each module.

Separately provided modules

Separately provided modules require downloading and installing a package on every host in your cluster first. See the category pages below for links to installation instructions:

  • Extensions — open source extensions that require a separate package install.
  • Procedural languages — additional languages for writing database functions.
  • External components — tools that integrate with WarehousePG but aren't database extensions.

For a complete list of available modules in each category, see Additional Supplied Modules.