JBoss+PostgreSQL

「JBoss+PostgreSQL」の編集履歴（バックアップ）一覧はこちら

「JBoss+PostgreSQL」(2006/01/16 (月) 00:08:08) の最新版変更点

追加された行は緑色になります。

削除された行は赤色になります。

* Database initialization

 root# mkdir /usr/local/pgsql/data
 root# chown postgres /usr/local/pgsql/data
 root# su postgres
 postgres$ initdb -D /usr/local/pgsql/data

** Starting DB

 $ postmaster -D /usr/local/pgsql/data >logfile 2>&1 &

 pg_ctl start -l logfile

* Setup

** Copy JDBC driver
Copy posgresql.jar to $JBOSS_HOME/server/default/lib

** Copy postgres-service.xml 
Copy $JBOSS_HOME/docs/examples/jca/postgres-service.xml to 
$JBOSS_HOME/server/default/deploy

** Modify postgres-service.xml

* Database initialization

 root# mkdir /usr/local/pgsql/data
 root# chown postgres /usr/local/pgsql/data
 root# su postgres
 postgres$ initdb -D /usr/local/pgsql/data

** Starting DB

 $ postmaster -D /usr/local/pgsql/data >logfile 2>&1 &

 pg_ctl start -l logfile

** add user

 postgres=# create user name password 'password';
 CREATE ROLE
 postgres=# \du
                               List of roles
  Role name | Superuser | Create role | Create DB | Connections | Member of
 -----------+-----------+-------------+-----------+-------------+-----------
  name      | no        | no          | no        | no limit    |
  postgres  | yes       | yes         | yes       | no limit    |
 (2 rows)




* Setup

** Copy JDBC driver
Copy posgresql.jar to $JBOSS_HOME/server/default/lib

** Copy postgres-service.xml 
Copy $JBOSS_HOME/docs/examples/jca/postgres-service.xml to 
$JBOSS_HOME/server/default/deploy

** Modify postgres-service.xml