Web Help Desk on Mac OS X is unable to update to version 12.0.0, receiving an error that the database migration cannot run because PostgreSQL service is not started.
This issue may be caused by the Default shared memory settings for Mac OS X, which can be too low for the embedded PostgreSQL database to start.
The PostgreSQL Global Development Documentation recommends editing the /etc/sysctl.conf file, to contain variable assignments such as:
Always set up your preferred values using /etc/sysctl.conf, so the operating system saves the values across reboots. OS X system updates usually overwrite /etc/rc, so you should expect to have to redo these edits after each update.In OS X 10.2 and earlier, edit the commands directly above in the file /System/Library/StartupItems/SystemTuning/SystemTuning. Linux installations with external PostgreSQL databases may also require memory settings adjustment. See the PostgreSQL Global Development Documentation, 17.4 Managing Kernel Resources for more detailed information on increasing the shared memory limits for OS X, as well as for Linux.
Keep in mind that:
Note: If PostgreSQL does not start after editing the shared memory values, you may find that you have an additional Postgres driver in /Library/Java/Extensions overriding the Postgres driver provided with Web Help Desk. If this extra driver exists
in /Library/Java/Extensions, delete it before you restart Web Help Desk. Also, if you are using a Microsoft Exchange SSL connection, make sure you have applied the latest hotfix to your installation.