Recently, changes have been checked into the trunk to allow Cosmo to be configured to run against a PostgreSQL 8.2 database. Here are instructions for configuring Cosmo to run on PostgreSQL:

1. Download PostgresSQL JDBC driver (http://jdbc.postgresql.org/download.html). Make sure you download the latest JDBC 3 driver.
2. Copy jdbc driver jar to osaf-server-bundle-0.6-SNAPSHOT/tomcat/common/lib
3. Create database on PostgresSQL server. Make sure you specify UTF8 encoding.
4. Edit osaf-server-bundle-0.6-SNAPSHOT/etc/cosmo.properties. Comment and Uncomment the relevant properties for Postgres ( cosmo.hibernate.dialect and cosmo.hibernate.sql.booleanStringValue).
5. Edit osaf-server-bundle-0.6-SNAPSHOT/tomcat/conf/server.xml. Comment the current database Resource definition and uncomment the sample postgres one and configure to match your database.
6. Startup Cosmo

-- RandyLetness - 18 Dec 2006