HISOAP - HTTPD Installation [ PostgreSQL 初期設定 ]

PostgreSQL 初期設定	HTTPD Installation
	Last modified : 2001/02/20

■ データベース初期化（ユーザ「postgres」で）

$ source ~/.bashrc
$ initdb --pgdata=/usr/local/pgsql/data --pglib=/usr/local/pgsql/lib

■ ユーザ登録（postgresで）

$ source ~/.bashrc
$ createuser nobody

Ver6.5以前	Enter user's postgres ID or RETURN to unix user ID:65534> ← [Enter]（ユニークなユーザ管理番号） Is user "nobody" allowed to create databese (y/n) n Is user "nobody" a superuser? (y/n) n createuser: nobody was successfully added Shall I create a database for "nobody" (y/n) n ← 専用ＤＢは作成しません
Ver7.0以降	Shall the new user be allowed to create databases? (y/n) n Shall the new user be allowed to create more new users? (y/n) n CREATE USER

$ source ~/.bashrc
~~$ destroyuser nobody~~
$ dropuser nobody

$ source ~/.bashrc
$ createuser editor

Ver6.5以前	Enter user's postgres ID or RETURN to unix user ID:65535> ← [Enter]（ユニークなユーザ管理番号） Is user "editor" allowed to create databese (y/n) y Is user "editor" a superuser? (y/n) n createuser: editor was successfully added
Ver7.0以降	Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y CREATE USER

$ source ~/.bashrc
$ createuser root
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER

■ データベース作成

$ source ~/.bashrc
$ createdb mast

$ source ~/.bashrc
~~$ destroydb mast~~
$ dropdb mast