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@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