1 최신버전 다운로드

2 압축풀기 (루트유저로 접속)

3 설치 (설치 및 사용자와 그룹 생성)

4 사용자 추가

5 환경설정

6 실행 및 확인

7 참고자료

8 CentOS 6.0에 설치

9 설치문서

su
cd /usr/local/src
wget http://ftp.postgresql.org/pub/source/v9.2.2/postgresql-9.2.2.tar.gz

tar zxvf postgresql-9.2.2.tar.gz

cd /usr/local/src/postgresql-9.2.2
./configure
make
make install

mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
adduser postgres
chown -R postgres:postgres /usr/local/pgsql 

su postgres
cd $HOME
vi .bash_profile


PGDATA=/usr/local/pgsql/data
PGLIB=/usr/local/pgsql/lib
MANPATH=$MANPATH:/usr/local/pgsql/man
PATH=$PATH:/usr/local/pgsql/bin

export  PGDATA PGLIB MANPATH PATH 

/etc/init.d/postgresql start
su - postgres
initdb -D /usr/local/pgsql/data
postgres -D /usr/local/pgsql/data >logfile 2>&1 
createdb test
psql test

mydb=# select current_date;

• postgresql.conf 간단한게 1
  
  

• http://www.postgresql.org/download/linux/redhat/