Install all contrib modules in PostgreSQL using souce code

Contrib modules are extensions for PostgreSQL. They provide additional functionality which is not part of PostgreSQL by default. To install the contrib modules follow the below procedure.

1) Install PostgreSQL manually
2) Set the environment variables (include the postgres locations in PATH and LD_LIBRARY_PATH variables).
3) When you untar the source code you can see a folder contrib in that

4) enter into contrib directory
cd contrib

5) execute “make” , “make install” commands
make install

This will complete the installation of all the extensions. You can see the “.control” , “.sql” files created in “/home/postgres/SOFTWARE_9.6/share/extension” location.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s