Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

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,098 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