Installing Postgresql from source on Linux.

1. 소스파일을 다운받는다.

wget http://ftp.postgresql.org/pub/source/v9.1.5/postgresql-9.1.5.tar.gz

2. 압축을 푼다.

tar -xzvf postgresql-9.1.5.tar.gz

3. 필요한 라이브러리를 설치한다.

apt-get install libreadline-dev zlib1g-dev

4. postgresql을 설치한다.

./configure

make

make install

adduser postgres

mkdir /usr/local/pgsql/data

chown postgres /usr/local/pgsql/data

su - postgres

/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &

/usr/local/pgsql/bin/createdb test

/usr/local/pgsql/bin/psql test