Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux