Running PostgreSQL on Solaris 8

This article was first written in February 2004 for
the BeezNest technical website (http://glasnost.beeznest.org/articles/107)

The default values for Shared Memory in Sun’s Solaris (starting from 2.6, at least) are set too low to run.

Here is how to change it (see also PostgreSQL’s Admin Guide, Managing Kernel Ressources):

The relevant settings can be changed in /etc/system, for example:

set shmsys:shminfo_shmmax=0x2000000 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=256 set shmsys:shminfo_shmseg=256 set semsys:seminfo_semmap=256 set semsys:seminfo_semmni=512 set semsys:seminfo_semmns=512 set semsys:seminfo_semmsl=32

You need to reboot to make the changes effective.

See also http://www.sunworld.com/swol-09-1997/swol-09-insidesolaris.html for information on shared memory under Solaris.


Related Posts

HOWTO Install and maintain free software easily under Solaris: pkg-get

This article was first written in August 2004 for the BeezNest technical website...

Installing Squid on ZFS

The recommended filesystem for Squid on OpenSolaris is ZFS: http://wiki.squid-cache.org/BestOsForSquid It is also...

Quick Contact Form