DB環境(PostgreSQL)

PostgreSQLでDB環境を設定

DBユーザ作成

 # su - postgres
 $ createuser -P roundcube
 Enter password for user "roundcube": ******
 Enter it again: ******
 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

DB作成

 $ createdb -U roundcube -O roundcube roundcube
 createdb 
 $ psql -l
           List of databases
     Name     |    Owner     | Encoding 
--------------+--------------+----------
 roundcube    | roundcube    | EUC_JP

初期テーブル定義

 $ psql -U roundcube roundcube < SQL/postgres.initial.sql