Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Web Help Desk (WHD) > Increase WHD database connections on OS X

Increase WHD database connections on OS X

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

Views: 47 Votes: 0 Revisions: 8

Issue

Web Help Desk’s (WHD’s) embedded PostgreSQL database accepts only 25 or fewer connections on Mac OS X. The database may also have trouble starting up.

Cause

OS X’s default 4MB Shared Memory system property limits WHD’s embedded PostgreSQL database to just 25 open connections. You may have problems starting the embedded PostgreSQL database if the property is less than the 4MB default value.

Solution

To increase the number of open database connections and ensure the embedded database is able to start up, reset the OS X Shared Memory system property. The PostgreSQL 9.2.4 Documentation provides the following instructions for resetting the OS X Shared Memory system property.

For Mac OS X systems running 10.3.9 and later, edit the file /etc/sysctl.conf. This file must contain five variable assignments such as the following:

kern.sysv.shmmax=1073741824
kern.sysv.shmmin=1
kern.sysv.shmmni=32
kern.sysv.shmseg=8
kern.sysv.shmall=262144

This platform measures SHMALL in 4 KB pages.

Note that in some OS X versions, all five shared-memory parameters must be set in /etc/sysctl.conf, or the values will be ignored.

Be aware that recent releases of OS X ignore attempts to set SHMMAX to a value that is not an exact multiple of 4096.

In OS X 10.5 and later, you can change all but the SHMMNI value using sysctl. But setting up your preferred values via /etc/sysctl.conf is the most stable configuration, because it ensure the values are kept across reboots. In older OS X versions, you need to reboot to have changes in the shared memory parameters take effect.

If you are running a version of OS X older than 10.3.9, you must edit the file /etc/rc and change the values for the following commands:
sysctl -w kern.sysv.shmmax
sysctl -w kern.sysv.shmmin
sysctl -w kern.sysv.shmmni
sysctl -w kern.sysv.shmseg
sysctl -w kern.sysv.shmall

OS X system updates usually overwrite /etc/rc, so expect to redo your edits after each update.

In OS X 10.2 and earlier, create these commands in the file /System/Library/StartupItems/SystemTuning/SystemTuning.

For more information, refer to the PostgreSQL 9.2 Documentation’s Section 17.4. Managing Kernel Resources.

Issue

Web Help Desk’s (WHD’s) embedded PostgreSQL database accepts only 25 or fewer connections. The database may also have trouble starting up.

Cause

OS X’s default 4MB Shared Memory system property limits WHD’s embedded PostgreSQL database to just 25 open connections. You may have problems starting the embedded PostgreSQL database if the property is less than the 4MB default value.

Solution

To increase the number of open database connections and ensure the embedded database is able to start up, reset the OS X Shared Memory system property.

The PostgreSQL 9.2.4 Documentation provides the following instructions, in Chapter 17. Server Setup and Operation, 17.4. Managing Kernel Resources, 17.4.1. Shared Memory and Semaphores, under the Mac OS X subheading:

Create a file named /etc/sysctl.conf. The file must contain five variable assignments such as the following:

sysctl -w kern.sysv.shmmax

sysctl -w kern.sysv.shmmin

sysctl -w kern.sysv.shmmni

sysctl -w kern.sysv.shmseg

sysctl -w kern.sysv.shmall

SHMALL is measured in 4 KB pages on this platform.

Note that in some OS X versions, all five shared-memory parameters must be set in /etc/sysctl.conf, or the values will be ignored.

Beware that recent releases of OS X ignore attempts to set SHMMAX to a value that isn't an exact multiple of 4096.

In older OS X versions, you will need to reboot to have changes in the shared memory parameters take effect. In OS X 10.5 and later, you can change all but the SHMMNI value using sysctl. But setting up your preferred values via /etc/sysctl.conf is the most stable configuration, because it ensure the values are kept across reboots.

The file /etc/sysctl.conf is only honored in OS X 10.3.9 and later. If you are running a previous OS X 10.3.x release, you must edit the file /etc/rc and change the values in the following commands:

sysctl -w kern.sysv.shmmax

sysctl -w kern.sysv.shmmin

sysctl -w kern.sysv.shmmni

sysctl -w kern.sysv.shmseg

sysctl -w kern.sysv.shmall

/etc/rc is usually overwritten by OS X system updates, so expect to redo these edits after each update.

In OS X 10.2 and earlier, these commands in the file /System/Library/StartupItems/SystemTuning/SystemTuning.

For more information, refer to the PostgreSQL 9.2 Documentation’s Section 17.4. Managing Kernel Resources.

Last modified
04:41, 23 Jun 2016

Tags

Classifications

Public