PostgreSQL

Installation

Linux Library 확인

아래 lib가 없으면 yum install로 모두 설치한다. readline
readline-devel
ncurses
ncurses-devel
zlib
zlib-devel
make
gcc

최신 버전 Download

http://www.postgres.org

압축 풀기

$ tar zxvf postgresql-9.2.2.tar.gz

설치

$ cd postgresql-9.2.2 $ ls OPYRIGHT GNUmakefile.in HISTORY INSTALL Makefile README aclocal.m4 config configure configure.in contrib doc src $ ./configure --prefix=/mnt/postsql $ make && make install ... ... PostgreSQL installation complete.

사용자 추가

$ useradd -d /home/ndap ndap $ mkdir /mnt/postsql/data $ chown -R ndap:ndap /mnt/postsql

환경설정

$ su - ndap $ vi ~/.bash_profile PGDATA=/mnt/postsql/data PGLIB=/mnt/postsql/lib MANPATH=$MANPATH:/mnt/postsql/man PATH=$PATH:/mnt/postsql/bin export PGDATA PGLIB MANPATH PATH

실행

$ initdb -D /mnt/postsql/data Success. You can now start the database server using: postgres -D /mnt/postsql/data or $ pg_ctl -D /mnt/postsql/data/ -l logfile start server starting

만약 실행 중 "pg_ctl: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory" Error가 발생한다면 다음과 같이 한다

$ su - root $ ldconfig /mnt/postsql/lib/

동작 확인

# create database & table $ createdb ndap $ psql ndap psql (9.2.2) Type "help" for help. ndap=# create table ndap(id varchar(20)); CREATE TABLE ndap=# insert into ndap values ('hellodb'); INSERT 0 1 ndap=# select * from ndap; id --------- hellodb (1 row) ndap=# \q # drop database $ dropdb ndap

외부 접근 설정

아래의 Code를 추가및 수정을 한다.

• $ vi /mnt/postsql/data/pg_hba.conf ----------------------------------------------- host all all 0.0.0.0/0 trust # 추가

$ vi /mnt/postsql/data/postgresql.conf ----------------------------------------------- listen_addresses = '*' # 수정 port = 5432 # 수정 max_connections = 100 # 수정

Code를 수정한 뒤, PostgreSQL을 Restart한다.

$ pg_ctl -D /mnt/postsql/data/ -l logfile restart