Обсуждение: FATAL: shmat(id=4096103) failed: Cannot allocate memory

Поиск
Список
Период
Сортировка

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

От
CS DBA
Дата:
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
---------------------------------------------


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

От
Tom Lane
Дата:
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