16.3. Installing Additional Supplied Modules

Postgres Pro comes with a huge set of server extensions, or modules. On Windows, these extensions are always installed. On Linux, they are included into the postgrespro-contrib package which may or may not be installed. If it is installed, you already have binary files for these extensions in the system and only need to enable it in the database in order to use it.

Typically, you only need to issue the following SQL command:

CREATE EXTENSION module_name

For details, see CREATE EXTENSION.

To get the list of extensions available in your Postgres Pro installation, view the pg_available_extensions system catalog.

Appendix F contains documentation for extensions available in the installation.

Some extensions require shared libraries to be preloaded on server startup.

If you want to use such an extension, you need to add parameter

shared_preload_libraries = 'lib1, lib2, lib3'

into postgresql.conf of your Postgres Pro database instance and restart the server. After that you can issue the CREATE EXTENSION statement.