Re: Unable to allocate 2G of shared memory on wheezy

2014-06-18 13:37:15 EDT FATAL: could not map anonymous shared memory:
Cannot allocate memory
2014-06-18 13:37:15 EDT HINT: This error usually means that PostgreSQL's
request for a shared memory segment exceeded available memory or swap
space. To reduce the request size (currently 8826445824 bytes), reduce
PostgreSQL's shared memory usage, perhaps by reducing shared_buffers or
max_connections.

ipcs -m

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status

Dave Cramer

On 18 June 2014 15:15, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Dave Cramer <davecramer(at)gmail(dot)com> writes:
> > To reduce the request size [FAILently 2232950784 bytes), reduce
> > PostgreSQL's shared memory usage,
>
> This error message is a bit garbled :-(. It would've been useful
> to know the specific errno, but you've trimmed out that info.
>
> Perhaps it's failing because you already have ~10G in shared memory
> segments? "sudo ipcs -m" might be illuminating.
>
> regards, tom lane
>