홈페이지
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:
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:
Trackback URL : http://apollo89.com/blog/trackback/230
rss