I installed posgresql on Ubuntu:
Operating System: Ubuntu
You need the following libraries:
Go to synaptic manager and install the following two things.
1. Bison
2. Flex
After this is done. Download postgresql .gz from the ftp site:
ftp://ftp.postgresql.org/pub/source/8.5alpha1/
Now follow the steps given below:
mv postgresql-8.5alpha1.tar.gz /usr/local/src
cd /usr/local/src
tar -xzvf postgresql-8.5alpha1.tar.gz
./configure –without-readline
make
make install
Note:Readline will definitely give problems. so, don’t break your head, just add –without-readline.
Related links you might need for more clarifications:
http://www.postgresql.org/docs/8.1/interactive/installation.html