PostgreSQL version 8.3 was used in all GECAMed installations prior to 1.2.00. Starting with version 1.2.00 GECAMed comes equipped with PostgreSQL 9.1, because versions inferior to 9.0 are not compatible with Mac OS X Lion (10.7.x) and higher. You must must therefore be very careful when upgrading your Mac OS to 10.7 or higher, if you're already runnig a GECAMed server with PostgreSQL older than 9.0.

A Mac OS X 6 → 7 upgrade (Snowleopard to Lion) is possible, but You need to upgrade your PostgreSQL first. To do so we suggest one of the following two methods.

Right now we do not recommend to upgrade from Mac OS 10.6 to 10.7 if you have a GECAMed installation older than version 1.2.xx running on it, because we can not guarantee that Mac OS 10.7 runs a PostgreSQL prior to version 9. However, you can migrate Postgress 8.3 to 9.1 still being on Mac OS 10.6, and then upgraqde to Mac OS 10.7.

We propose two options how to do that, and both will require to export and re-import the database at one tme or another. So do this only if you feel comfortable with backuping and restoring PostgreSQL databases. In case you don't please referr to our support comany page at http://www.gecamed.lu/support to get professional help.

• First Option - Reistalling GECAMed
  1. Update your GECAMed to version 1.2.00 or higher (download the Updater and the Installer for this version)
  2. Backup the GECAMed database (using for example the GECAMed backup tool: “Tools” → “Backup Database”)
  3. Uninstall GECAMed
  4. Install GECAMed (the same version, you updated to) using the Installer. This will install GECAMed with PostgreSQL version 9.1.
  5. Restore the old database (“/Library/PostgreSQL/9.1/bin/pg_restore -d gecamed -U gecamed /Application/GECAMed/gecamed_backup/«backup-file-name»” - you might be ask for the password of the user “gecamed”. You can find the password under “/Applications/GECAMed/jboss-4.0.5.GA/server/default/conf/gecamed_server.properties”)

• Second Option - Upgrading PostgreSQL
  1. Backup the GECAMed database (using for example the GECAMed backup tool: “Tools” → “Backup Database”)
  2. Uninstall PostgreSQL 8.3 (“/Library/PostgreSQL/8.3/uninstall-postgreql”)
     If you do not delete the data folder in the folder where the uninstaller lies, you will have all your databases again if you reinstall the old PostgreSQL version. But you need to install exactly the same postgres version, because the data is not compatible with any other version (no matter if older or newer).
  3. Download and install PostgreSQL 9.1.
  4. Create the database role “gecamed” (you can use PGAdmin3 for that)
     Use the same password as the gecamed-user of the old postgres version. You can find the password under “/Applications/GECAMed/jboss-4.0.5.GA/server/default/conf/gecamed_server.properties”
  5. Restore the old database (“/Library/PostgreSQL/9.1/bin/pg_restore -d gecamed -U gecamed /Application/GECAMed/gecamed_backup/«backup-file-name»” - you might be ask for the password of the user “gecamed”).

Nowyou can update your Mac OS X from 10.6 to 10.7.

This will also install a new Java version. Therefore the java version fix script has as also to be applied (see Fix the Java version used by the JBoss).