Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TDyLJ-0006Ji-7F for pgsql-docs@postgresql.org; Tue, 18 Sep 2012 14:00:01 +0000 Received: from dub0-omc1-s28.dub0.hotmail.com ([157.55.0.227]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TDyLH-000435-4E for pgsql-docs@postgresql.org; Tue, 18 Sep 2012 14:00:00 +0000 Received: from DUB103-W29 ([157.55.0.238]) by dub0-omc1-s28.dub0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Tue, 18 Sep 2012 06:59:53 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_2a1af631-2f84-4243-a43a-475a955bcebd_" X-Originating-IP: [41.142.255.38] From: data tanger To: Subject: Issue with SHMALL parameter Date: Tue, 18 Sep 2012 15:59:53 +0200 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 18 Sep 2012 13:59:53.0753 (UTC) FILETIME=[E0D0B890:01CD95A5] X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201209/16 X-Sequence-Number: 7468 --_2a1af631-2f84-4243-a43a-475a955bcebd_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi=2C I'm using postgresql 9.1 as my database server on a linux server that has 8= GB of RAM. After I changed the shared_buffers parameter to 2GB=2C I get the following = error when I try to start postgres: FATAL: could not create shared memory segment: Cannot allocate memoryDETAI= L: Failed system call was shmget(key=3D5432001=2C size=3D2221539328=2C 036= 00). Here are the shmall and the shmax params of my server: #cat /proc/sys/kernel/shmmax 68719476736 #cat /proc/sys/kernel/shmall 4294967296 So as you see=2C shmall is greater than the requested size by postgres. Any= one have and idea? thank you = --_2a1af631-2f84-4243-a43a-475a955bcebd_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi=2C

I'm using postgresql 9.1 as my database server on = a linux server that has 8 GB of RAM.

After I chang= ed the shared_buffers parameter to 2GB=2C I get the following error when I = try to start postgres:

FATAL: =3Bcould not create shared memory segment: Cannot allocate me= mory

DETAIL: =3BFailed system= call was shmget(key=3D5432001=2C size=3D2221539328=2C 03600).

Here are the shmal= l and the shmax params of my server:

#cat /proc/sys/kernel/shmmax =3B =3B = =3B

68719476736

#cat /proc/sys/kernel/shmall =3B =3B =3B

4294967296

So as you see=2C shmall= is greater than the requested size by postgres. Anyone have and idea?

thank you

= --_2a1af631-2f84-4243-a43a-475a955bcebd_--