Re: Shared memory error using initdb on Solaris 8 - Mailing list pgsql-admin

From Kevin Schroeder
Subject Re: Shared memory error using initdb on Solaris 8
Date
Msg-id 406e01c43f55$32d6bb40$0200a8c0@WORKSTATION
Whole thread Raw
In response to Re: Shared memory error using initdb on Solaris 8  (jseymour@LinxNet.com (Jim Seymour))
List pgsql-admin
There we go.  For reference, what page did you get that info and what did
you search for to get it?

Kevin

----- Original Message -----
From: "Jim Seymour" <jseymour@LinxNet.com>
To: <pgsql-admin@postgresql.org>
Sent: Friday, May 21, 2004 10:57 AM
Subject: Re: [ADMIN] Shared memory error using initdb on Solaris 8


> >
> > 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html


pgsql-admin by date:

Previous
From: jseymour@LinxNet.com (Jim Seymour)
Date:
Subject: Re: Shared memory error using initdb on Solaris 8
Next
From: jseymour@LinxNet.com (Jim Seymour)
Date:
Subject: Re: Shared memory error using initdb on Solaris 8