Re: FATAL: shmat(id=4096103) failed: Cannot allocate memory - Mailing list pgsql-admin

From Tom Lane
Subject Re: FATAL: shmat(id=4096103) failed: Cannot allocate memory
Date
Msg-id 27470.1323837026@sss.pgh.pa.us
Whole thread Raw
In response to FATAL: shmat(id=4096103) failed: Cannot allocate memory  (CS DBA <cs_dba@consistentstate.com>)
List 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

pgsql-admin by date:

Previous
From: CS DBA
Date:
Subject: FATAL: shmat(id=4096103) failed: Cannot allocate memory
Next
From: Robert Matthew Cook
Date:
Subject: Postgresql scheme standards tool