Re: FATAL: shmat(id=3342337) failed: Cannot allocate memory

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: FATAL: shmat(id=3342337) failed: Cannot allocate memory
Date: 2013-04-24 06:17:32
Message-ID: 517778FC.8090804@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/23/2013 11:08 PM, Khangelani Gama wrote:
> Hi John
>
> Yes that's the whole messege
>

well, try something like...

kernel.shmmax = 4294967295
kernel.shmall = 268435456

at the end of /etc/sysctl.conf, then execute `sysctl -p` and try to
start postgres again.

(it really doesn't matter if you set those kernel limits too large, they
have no negative impact, they are simply quota, the max allowed. The
only reason to restrict them is on a shared system with
hostile/malicious users like students who might mess with grabbing
excessive memory and causing a denial of service. )

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Khangelani Gama 2013-04-24 06:45:34 Re: FATAL: shmat(id=3342337) failed: Cannot allocate memory
Previous Message Khangelani Gama 2013-04-24 06:13:35 Re: FATAL: shmat(id=3342337) failed: Cannot allocate memory