Re: Problems allocating more memory - Mailing list pgsql-admin

From Chris Fossenier
Subject Re: Problems allocating more memory
Date
Msg-id sa0586de.032@mail.pcguru.com
Whole thread Raw
In response to Problems allocating more memory  ("Chris Fossenier" <Chris@pcguru.com>)
List pgsql-admin
I have 2GB of RAM and dual CPUs...the machine is raunchy.

Chris.

>>> Peter Eisentraut <peter_e@gmx.net> 11/05/00 04:02PM >>>
Chris Fossenier writes:

> > 001105.14:42:28.236  [1124] IpcMemoryCreate: shmget failed (Invalid
> > argument) key=5432001, size=286224384, permission=600
> > This type of error is usually caused by an improper
> > shared memory or System V IPC semaphore configuration.
> > For more information, see the FAQ and platform-specific
> > FAQ's in the source directory pgsql/doc or on our
> > web site at http://www.postgresql.org.
> > 001105.14:42:28.237  [1124] FATAL 1:  ShmemCreate: cannot create region
>
> I have re-compiled my kernel and increased SHMMAX.  Are there some other memory settings I should be making?

Are you sure you have 273 MB of memory and want to dedicate all to shared
buffers?  I don't believe that will help a lot.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Problems allocating more memory
Next
From: Silvan Calarco
Date:
Subject: psql -U postgres does not require a password