1. Oracle 1). 서버환경 – 서버 주소 : 127.0.0.1 – 서비스 포트 : 1521 2). JDBC 설정 – Driver 클래스 : oracle.jdbc.driver.OracleDriver – URL 형식 : jdbc:oracle:thin:@127.0.0.1:1521 2. MySQL 1). 서버환경 – 서버 주소 : 127.0.0.1 – 서비스 포트 … Continue reading
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: |