FATAL: shmat(id=4096103) failed: Cannot allocate memory

[Reindl Harald]

Am 14.12.2011 02:54, schrieb CS DBA:
>>> I installed Postgresql from source and set SHMMAX to 2198066816
>>> I set postgres to use 2GB for shared_buffers and I get this when I try to start:
>>>
>>> FATAL:  shmat(id=4096103) failed: Cannot allocate memory
>>>
>>> The only real difference from Fedora 14 is that on Fedora 16 I'm using the PAE kernel
>>> Thoughts?
>> /etc/sysctl.conf -> kernel.shmall
>>
> 
> I set shmall to the same as shmmax, it didnt help
> 
> root at Issac # sysctl -a | grep -i shm
> kernel.shmmax = 2198066816
> kernel.shmall = 2198066816

this value maybe too small if you force pgsql to use 2 GB at it's own
because it is not the only process using SHM

> I have 8GB of ram and I'm using the following kernel:
> # uname -a                                                          
> Linux Issac.consistentstate.com 3.1.5-1.fc16.i686.PAE #1 SMP Fri Dec 9 18:02:46 UTC 2011 i686 i686 i386 GNU/Linux

generally a bad idea using any i686 kernel on a machine with 8 GB memory
i686 is legacy these days and PAE can not fix all problems of 32bit
but this should not be the root-cause for the shm-problem




-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
URL: <http://lists.fedoraproject.org/pipermail/users/attachments/20111214/b4583e01/attachment.sig>