PostgreSQL 8.3.3 리눅스 설치..

홈페이지 : http://www.postgresql.org/

]$ ./configure
]$ gmake
]$ su
]# gmake install
]# adduser postgres
]# mkdir /usr/local/pgsql/data
]# chown postgres /usr/local/pgsql/data
]# su - postgres
]$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
]$ /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
]$ /usr/local/pgsql/bin/createdb test
]$ /usr/local/pgsql/bin/psql test

* 비밀번호 변경.

test=# alter user postgres with password '********';
ALTER ROLE
test=#

]$ vi /usr/local/pgsql/data/pg_hba.conf

METHOD의 trust를 password로 변경 후 재시작.

]$ /usr/local/pgsql/bin/pg_ctl restart -D /usr/local/pgsql/data/
waiting for server to shut down....
server stopped
server starting
]$ /usr/local/pgsql/bin/psql test
Password: