Before you start

Make sure that you have set utf8 as default/server-character-set make sure Postgres is listening on TCP/IP connections! To verify if Postgres connection is working: OpenMeetings will automatically create all tables in the database and all tables should have utf8 as encoding/collation! If you encounter issues, you can drop the db again and delete the file $red5/webapps/openmeetings/conf/install.xml and then run the web based installer again

Steps todo

Rename: $red5/webapps/openmeetings/WEB-INF/classes/META-INF/postgres_persistence.xml to $red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml Prepare Database Settings - go to openmeetings_version_no_xx/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml Alter config values in persistence.xml DB_HOST USER_NAME USER_PASS with your values Run red5-service and goto the web-based installer: http://localhost:5080/openmeetings/install

Postgres Sample Configuration

There is a sample configuration for Postgres that ships with every release in: /webapps/openmeetings/WEB-INF/classes/META-INF/postgres_persistence.xml