[opencms-dev] opencms with postgresql

[Ramon Buckland]

Hi,

Has anyone added support to opencms for postgresql ?
Im currently giving it a go, then figured this would be the best
place to be asking :-)

I have found the WEB-INF/config/opencms.properties
and added the relevant lines I figured would be necessary .. 
but the system when running through the setup gets stuck in a 
loop after the first page of selecting 'Standard' or 'Advanced'.

Any pointers would be great.. 
Kind Regards
Ramon.

---- excerpts from WEB-INF/config/opencms.properties ----
resourcebroker.postgresql.class=com.opencms.file.genericSql.CmsResourceBroker
resourcebroker.postgresql.pool=jdbc:opencmspool:postgresql
resourcebroker.postgresql.online.pool=jdbc:opencmspool:postgresqlonline
resourcebroker.postgresql.backup.pool=jdbc:opencmspool:postgresqlbackup
resourcebroker.postgresql.digest=MD5
resourcebroker.postgresql.digest.fileencoding=UTF-8

# Parameters for the postgresql connection-pool
pool.postgresql.driver=org.postgresql.Driver
...

# Parameters for the postgresql online connection-pool
pool.postgresqlonline.driver=org.postgresql.Driver
...
# Parameters for the postgresql backup connection-pool
pool.postgresqlbackup.driver=org.postgresql.Driver
...