PostgreSQL 설치

PostgreSQL 설치

 postgresql-7.4.5.tar.gz 설치
  [root@localhost postgresql-7.4.5] ./configure
  [root@localhost postgresql-7.4.5] gmake
  [root@localhost postgresql-7.4.5] su
  [root@localhost postgresql-7.4.5] gmake install

postgre 그룹 및 유저추가:
  [root@localhost postgresql-7.4.5] groupadd postgres
  [root@localhost postgresql-7.4.5] adduser postgres -g postgres -d /usr/local/pgsql
  [root@localhost postgresql-7.4.5] mkdir /usr/local/pgsql/data
  [root@localhost postgresql-7.4.5] chown postgres.postgres /usr/local/pgsql -R
  [root@localhost postgresql-7.4.5] su - postgres
  [root@localhost postgresql-7.4.5] /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
postgreSQL 의 실질적인 설치 완료!!

 

 

실행 테스트  
  [root@localhost postgresql-7.4.5] /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data &
  [root@localhost postgresql-7.4.5] /usr/local/pgsql/bin/createdb test
  [root@localhost postgresql-7.4.5] /usr/local/pgsql/bin/psql test

  

테스트
   test=# create table test(aaa char(10));
   test=# insert into test values('test ok');
   test=# \q

[출처] Apache2 + PHP5 + PostgreSQL 설치|작성자 시간은금