Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I install the postgresql-contrib module in an existing database?

I'm using postgresql 9.1.6 on CentOS. I would like to install the postgresql-contrib module using a binary file, but I can't find it online. I'm unsure if I can install this after already installing postgresql. Is it possible to do this?

I installed postgresql in the following way:

wget http://ftp.postgresql.org/pub/source/v9.1.6/postgresql-9.1.6.tar.gz
tar -xzf postgresql-9.1.6.tar.gz 
cd postgresql-9.1.6./configure --prefix=$HOME
make 
make install

I am currently using the databases within this install and would prefer not to reinstall it (if possible).

I understand that once I install this I can use a function in the following way:

create extension tablefunc ;

EDIT: If I followed the instructions from here, does gmake and gmake install affect an existing database?

like image 389
djq Avatar asked Oct 14 '12 14:10

djq


1 Answers

You might be hard pressed to find the contrib modules as binary distributions; however, the very page you linked has explicit instructions on how to build the contrib modules:

When building from the source distribution, these modules are not built automatically. You can build and install all of them by running

gmake
gmake install

in the contrib directory of a configured source tree; or to build and install just one selected module, do the same in that module's subdirectory.

Alternatively, you could try using yum (the package is postgresql-contrib.x86_64), but I can't vouch for the results of this if you installed Postgres from source.

like image 157
Smith Avatar answered Nov 15 '22 11:11

Smith