문서의 이전 판입니다!
# 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
# su - postgres # psql -d template1 template1=# CREATE USER 아이디 WITH PASSWORD '비밀번호'; template1=# CREATE DATABASE 디비이름 WITH ENCODING='utf-8' OWNER 아이디;
# 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)