Re: IpcMemoryCreate

From: Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)nl>
To: Joakim Bomelin <jbm(at)gronaverket(dot)se>, pgsql-general(at)postgresql(dot)org
Subject: Re: IpcMemoryCreate
Date: 2001-05-23 14:54:56
Message-ID: 3B0BCF3F.6EC22C74@osiris-it.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joakim Bomelin wrote:

> In Solaris 8, I get "IpcMemoryCreate: shmget(key=5432001, size=1236992,
> 03600) failed: Invalid argument" when I try to start postmaster. I can
> see that I don't have enough shared memory, and that I should change the
> SHMMAX parameter in the kernel.
> I'm not really up for recompiling the kernel, since I'm kinda new to
> Solaris. Is there any other way to get rid of this error? I hope so :)

Solaris has a dynamic kernel, so you don't have to rebuild.

You can edit the file :

/etc/system
* Oracle shared memory
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=250
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

these are some parameters from a solaris machine on which we run Oracle.

Regards,

Feite

>
>
> --
> Joakim Bomelin
> Gröna Verket AB
> 040-691 91 36
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Feite Brekeveld
feite(dot)brekeveld(at)osiris-it(dot)nl
http://www.osiris-it.nl

In response to

Browse pgsql-general by date

  From Date Subject
Next Message snpe 2001-05-23 15:33:58 Re: Simple question for SQL Student
Previous Message Tom Lane 2001-05-23 14:48:35 Re: Estimating costs (was Functional Indices)