#title PostgreSQL 설치
[[TableOfContents]]

==== 최신버전 다운로드 ====
http://www.postgres.org
{{{
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;
}}}
==== 참고자료 ====
 * [http://blog.naver.com/PostView.nhn?blogId=jinukey&logNo=140066070952&widgetTypeCall=true postgresql.conf 간단한게 1]

==== CentOS 6.0에 설치 ====
yum install postgresql90-server postgresql90-contrib
service postgresql-9.0 initdb 
service postgresql-9.0 start
ls /usr/pgsql-9.0/

==== 설치문서 ====
 * http://www.postgresql.org/download/linux/redhat/