PostgreSQL 8.3.3 리눅스 설치..
홈페이지 : http://www.postgresql.org/
|
1 2 3 4 5 6 7 8 9 10 11 12 |
]$ ./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 |
* 비밀번호 변경.
|
1 2 3 |
test=# alter user postgres with password '********'; ALTER ROLE test=# |
|
1 |
]$ vi /usr/local/pgsql/data/pg_hba.conf |
METHOD의 trust를 password로 변경 후 재시작.
|
1 2 3 4 5 6 |
]$ /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: |