pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFATAL: shmat(id=4096103) failed: Cannot allocate memory
2+ messages / 2 participants
[nested] [flat]
* FATAL: shmat(id=4096103) failed: Cannot allocate memory
@ 2011-12-14 02:01 CS DBA <cs_dba@consistentstate.com>
2011-12-14 04:30 ` Re: FATAL: shmat(id=4096103) failed: Cannot allocate memory Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: CS DBA @ 2011-12-14 02:01 UTC (permalink / raw)
To: pgsql-admin
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
---------------------------------------------
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: FATAL: shmat(id=4096103) failed: Cannot allocate memory
2011-12-14 02:01 FATAL: shmat(id=4096103) failed: Cannot allocate memory CS DBA <cs_dba@consistentstate.com>
@ 2011-12-14 04:30 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2011-12-14 04:30 UTC (permalink / raw)
To: CS DBA <cs_dba@consistentstate.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-12-14 04:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-12-14 02:01 FATAL: shmat(id=4096103) failed: Cannot allocate memory CS DBA <cs_dba@consistentstate.com>
2011-12-14 04:30 ` Re: FATAL: shmat(id=4096103) failed: Cannot allocate memory Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox