Submit a ticketCall us

WebinarDatabase Roundtable – Expert Database Professionals Feel Your Pain

In this video broadcast, Head Geek™ Tom LaRock is joined by Karen Lopez, Tim Chapman, and David Klee. They’ve known each other for many years, so this discussion was like four friends getting together to talk data and databases. They discussed diagnostic data collection, common performance root causes, reactive tuning versus proactive, and more. Join us for an engaging discussion on these topics! Plus, Tom LaRock will be available to answer your questions live.

Register now.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Failed Web Help Desk v12.0.0 upgrade on Mac OS X

Failed Web Help Desk v12.0.0 upgrade on Mac OS X

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 1,066 Votes: 0 Revisions: 10


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:


  • In some OS X versions, all five shared-memory parameters must be set in /etc/sysctl.conf, or the values are ignored.
  • Recent releases of OS X ignore SHMMAX  values that are not exact multiples of 4096.OS X measures SHMALL in 4 kb pages.
  • Older OS X versions require rebooting to enable changes in the shared memory.
  • As of OS X 10.5, using sysctl, it is possible to change all variables but SHMMNI on the fly, using the variables noted above.


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
/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.


Last modified