Re: initdb memory segment creation error - Mailing list pgsql-general

From Tom Lane
Subject Re: initdb memory segment creation error
Date
Msg-id 17296.1221135628@sss.pgh.pa.us
Whole thread Raw
In response to initdb memory segment creation error  (questions <questions.612@gmail.com>)
Responses Re: initdb memory segment creation error  (questions <questions.612@gmail.com>)
List pgsql-general
questions <questions.612@gmail.com> writes:
> I am getting this error with initdb while creating shared segment -
> "memory segment exceeded available memory or swap space.  To reduce the
> request size (currently 1785856 bytes), reduce PostgreSQL's shared_buffers
> parameter (currently 50)) and/or its max_connections parameter (currently
> 13)."
> Total memory is 256 MB and memory available to user processes is 178 MB.
> It's not an issue with shared segment exceeding SHMMAX but value of SHMMAX
> is 67108864 and SHMALL is 8192. It is not exactly a Postgresql problem but
> what am I missing here?

Hm, what else is running on the box?  PG itself should fit in 256MB but
if you've got other stuff hogging memory, you might have little choice
but to buy more RAM.

(You should also double-check what SHMALL is measured in on your
platform; maybe that 8192 isn't pages but bytes ...)

            regards, tom lane

pgsql-general by date:

Previous
From: Joao Ferreira gmail
Date:
Subject: about partitioning
Next
From: Tom Lane
Date:
Subject: Re: abusing plpgsql array variables