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