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

# cat /proc/meminfo

MemTotal: 8273364 kB
MemFree: 6455204 kB
Buffers: 99180 kB
Cached: 564436 kB
SwapCached: 0 kB
Active: 1191560 kB
Inactive: 500768 kB
Active(anon): 1032072 kB
Inactive(anon): 456 kB
Active(file): 159488 kB
Inactive(file): 500312 kB
Unevictable: 4284 kB
Mlocked: 4284 kB
HighTotal: 7473504 kB
HighFree: 5863364 kB
LowTotal: 799860 kB
LowFree: 591840 kB
SwapTotal: 1048572 kB
SwapFree: 1048572 kB
Dirty: 196 kB
Writeback: 0 kB
AnonPages: 1033004 kB
Mapped: 34528 kB
Shmem: 556 kB
Slab: 89048 kB
SReclaimable: 43168 kB
SUnreclaim: 45880 kB
KernelStack: 2584 kB
PageTables: 4512 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 5185252 kB
Committed_AS: 1167668 kB
VmallocTotal: 122880 kB
VmallocUsed: 6928 kB
VmallocChunk: 70836 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 8184 kB
DirectMap2M: 905216 kB

-----Original Message-----
From: Khangelani Gama [mailto:kgama(at)argility(dot)com]
Sent: Wednesday, April 24, 2013 8:09 AM
To: 'John R Pierce'; 'pgsql-general(at)postgresql(dot)org'
Subject: RE: [GENERAL] FATAL: shmat(id=3342337) failed: Cannot allocate
memory

Hi John

Yes that's the whole messege

# free -m

total used free shared buffers cached
Mem: 8079 1770 6309 0 95 549
-/+ buffers/cache: 1125 6953
Swap: 1023 0 1023

Thanks

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of John R Pierce
Sent: Wednesday, April 24, 2013 7:58 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] FATAL: shmat(id=3342337) failed: Cannot allocate
memory

On 4/23/2013 10:53 PM, Khangelani Gama wrote:
> We are running postgres 9.1 on CentOS 5. We can't start up postgres .
> It complains about memory allocation . Please help
>
> FATAL: shmat(id=3342337) failed: Cannot allocate memory
>

is that the entire error message? it usually says something about setting
kernel.shmmax and/or shmall... for most flavors of linux, you set these in
/etc/sysctl.conf (and then update the live system with "sysctl -p").

--
john r pierce 37N 122W
somewhere on the middle of the left coast

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential
information of Argility (Proprietary) Limited and/or its subsidiaries. Any review, use or dissemination thereof by anyone
other than the intended addressee is prohibited.If you are not the intended addressee please notify the writer immediately
and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability
for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.