postgresql install and inital on debian testing
时间：2010-09-22 来源：shuangquan
1. Install postgresql
2. Initial db cluster
3. start server
4. create database /usr/lib/postgresql/8.4/bin/createdb mydb
5. create user role /usr/lib/postgresql/8.4/bin/createuser user_name
6.alter user passwd su postgres psql postgres
alter user user_name with password 'new password'; 7.connect psql mydb mydb#
|
apt-get install postgresql |
2. Initial db cluster
|
/usr/lib/postgresql/8.4/bin/initdb -D directory_name |
3. start server
|
/usr/lib/postgresql/8.4/bin/pg_ctl -D initdb_directory_name |
4. create database /usr/lib/postgresql/8.4/bin/createdb mydb
5. create user role /usr/lib/postgresql/8.4/bin/createuser user_name
6.alter user passwd su postgres psql postgres
alter user user_name with password 'new password'; 7.connect psql mydb mydb#
相关阅读 更多 +
