pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: jseymour@LinxNet.com
To: pgsql-admin@postgresql.org
Subject: Re: Shared memory error using initdb on Solaris 8
Date: Fri, 21 May 2004 11:57:15 -0400 (EDT)
Message-ID: <20040521155715.E15B0430E@jimsun.LinxNet.com> (raw)

> 
> Hello,
>     I'm trying to install PostgreSQL 7.4.2 on a brand new SunFire 120 with
> 2GB of RAM but when I run initdb -D /usr/local/pgsql/data I get the
> following error:
> 
[snip]
> creating template1 database in /usr/local/pgsql/data/base/1... FATAL:  could
> not create shared memory segment: Invalid argument
> DETAIL:  Failed system call was shmget(key=1, size=1081344, 03600).
> HINT:  This error usually means that PostgreSQL's request for a shared
> memory segment exceeded your kernel's SHMMAX parameter.
[snip]
> 
> When I run ulimit -a I get
> 
[snip]

You're looking at the wrong thing.  You need to do:

    sysdef |egrep -i 'shm|sem'

> 
> There does not seem to be an option in initdb to reduce the shared buffers
> size.

It tries to reduce things as far as it "sanely" can to fit within
what's available.  You can hand-tweak initdb to over-ride its
limits, but you'd end-up with a sub-optimal installation.

>        Plus, with 2GB of RAM I don't know that I'd want to go below the
> "lowest common denominator" that Postgres defaults to.

Nope.  You need to adjust certain values by placing settings in
/etc/system and rebooting.  I use:

    /etc/system
        set shmsys:shminfo_shmmax=0x2000000  (33554432 decimal)
        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

I arrived at the above values from Google'ing.

Jim



view thread (5+ messages)  latest in thread

Message-ID: <20040521155715.E15B0430E@jimsun.LinxNet.com>
Permalink:  ../20040521155715.E15B0430E@jimsun.LinxNet.com/
Also on:    postgresql.org/message-id/20040521155715.E15B0430E@jimsun.LinxNet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jseymour@LinxNet.com
  Subject: Re: Shared memory error using initdb on Solaris 8
  In-Reply-To: <20040521155715.E15B0430E@jimsun.LinxNet.com>
  References: <20040521155715.E15B0430E@jimsun.LinxNet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox