PostgreSQL 설치

2012. 1. 12. 19:58개발/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

'개발 > postgresql' 카테고리의 다른 글

PostgreSQL 기본 클라이언트 psql 사용  (0) 2012.01.14