Deploying ICAT on Postgresql

[Alistair Mills]

I am pleased to report that it is possible to deploy ICAT on a postgresql database.  The only tricky bit is to find the correct driver class file in the postgress connector jar file and use the correct form of the properties.  For example:

driver=org.postgresql.ds.PGSimpleDataSource

icatProperties=url="'"jdbc:postgresql"'":user=amhosti_icat:password=secret:databaseName=amhosti_icat:portNumber=5432:serverName=am-hosting.com

A simple test which shows that it is possible to get ICAT to start on a Postgresql database does not mean that it is reliable and works well.

Alistair