Обсуждение: FATAL: shmat(id=4096103) failed: Cannot allocate memory
Hi All;
I just installed Fedora 16, I was running fedora 14.
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
Here's my current SHM kernel settings:
# sysctl -a | grep -i shm
kernel.shmmax = 2198066816
kernel.shmall = 2198066816
kernel.shmmni = 4096
kernel.shm_rmid_forced = 0
vm.hugetlb_shm_group = 0
Thoughts?
Thanks in advance
--
---------------------------------------------
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
www.consistentstate.com
---------------------------------------------
CS DBA <cs_dba@consistentstate.com> writes:
> 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
That's not really surprising in a 32-bit environment --- you've only got
4GB of address space, in fact I think only 3GB in Linux, and that space
is kind of fragmented. Install 64-bit or back down shared_buffers to
1GB or so.
regards, tom lane