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