Ever wanted to install the PostgreSql server with some custom options? Need to install the PostgreSql server from source code instead of pre-configured packages? This article guides you through a short installation procedure to get the PostgreSql server up and running!

Hide these ads

Show Ads
[edit] StepsObtain the source code from PostgreSQL website [1].
Unpack the source code package. Use the following bash/console command:

gunzip postgresql-8.3.3.tar.gz
tar xf postgresql-8.3.3.tar

postgresql-8.3.3 is the name of the current version. Future versions might differ in the 8.3.3 part.
A directory named postgresql-8.3.3 will be created under the current directory (the one you executed the above script from).
Change the current directory to the newly created one (postgresql-8.3.3)
Configure the source tree for your system and choose the installation options you want:
Default Configuration: run the command
./configure
on your bash/console
Custom Configuration (this is for advanced users only): you can set a lot of custom configuration options using command line options listed in the PostgreSql documentation [2]
Start the build process by executing the command line
gmake
in your console/bash. This might take a few minutes depending on your hardware. The last line displayed should be:
All of PostgreSQL is successfully made. Ready to install.
Install PostgreSql files by executing the bash/console command:
gmake install
which will install the files to /usr/local/pgsql unless you used the --prefix=PREFIX command lin