adminschool.net wiki

# apt-get install postgresql postgresql-client postgresql-dev libpg-perl libdbd-pg-perl

# apt-get install postgresql-8.1 postgresql-client-8.1 postgresql-client-common postgresql-common postgresql-server-dev-8.1 postgresql-contrib-8.1 postgresql-plperl-8.1 postgresql-plpython-8.1

1. 계정과 데이타베이스를 생성한다.

   # su - postgres
   # psql -d template1
   template1=# CREATE USER 아이디 WITH PASSWORD '비밀번호';
   template1=# CREATE DATABASE 디비이름 WITH ENCODING='utf-8' OWNER 아이디;

2. 예를 들어보자

   template1=# create user eecit with password 'userpassword';
   CREATE USER
   template1=# create database eecitdb with encoding='utf-8' owner eecit;
   CREATE DATABASE

# su -
# cd /etc/postgresql/8.1/main
# vi pg_hba.conf
모두 주석으로 막고 아래만 남김
host    all         all         0.0.0.0           0.0.0.0           password
local   all         postgres                                        trust
local   all         all                                             password
# /etc/init.d/postgresql-8.1 restart
# psql -d 디비이름 -U 아이디 -W

# psql -U postgres -l
          List of databases
    Name     |    Owner    | Encoding
-------------+-------------+----------
 eecit       | eecit       | UNICODE
 openwatcher | openwatcher | UNICODE
 template0   | postgres    | UNICODE
 template1   | postgres    | UNICODE
(4 rows)