Install all contrib modules in PostgreSQL using souce code

Posted on January 16, 2018 by viswamitra Leave a comment

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
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.