Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 475E8C77277 for ; Thu, 21 Jun 2012 00:35:36 -0300 (ADT) Received: from [210.83.216.121] (helo=edgesoft.cn) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ShYBB-00084d-Pk for pgsql-admin@postgresql.org; Thu, 21 Jun 2012 03:35:35 +0000 Received: from [172.18.63.139] (unknown [15.210.133.3]) (Authenticated sender: wangqi@edgesoft.cn) by mail.edgesoft.cn (Postfix) with ESMTPA id 94C1F8111 for ; Thu, 21 Jun 2012 11:35:13 +0800 (CST) Message-ID: <4FE29737.2040405@edgesoft.cn> Date: Thu, 21 Jun 2012 11:38:31 +0800 From: wangqi User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:13.0) Gecko/20120614 Thunderbird/13.0.1 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: about shared_buffer and kernel.shmmax Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 210.83.216.121 (failed) X-Pg-Spam-Score: 1.6 (+) X-Archive-Number: 201206/95 X-Sequence-Number: 39686 Hi everybody, shared_buffer maximum limit is ? I set shared_buffer more than 250G, I got error at startup pg. ------------------------------------------------------------------------ This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. You can either reduce the request size or reconfigure the kernel with larger SHMMAX. To reduce the request size (currently 439371702272 bytes), reduce PostgreSQL's shared_buffers parameter (currently 52428800) and/or its max_connections parameter (currently 104). ------------------------------------------------------------------------- but now kernel.shmmax = 966367641600 kernel.shmall = 235929600 -- ---------------------------------------------------- Yours sincerely, Qi Wang Edgesoft (China) Co.,Ltd F26th Block B,Zhongli Building, No.32 Huoju Road, Hi-Tech Zone,Dalian,China Zip:116023 Tel:+86-411-84753511 Fax:+86-411-84753577 http://www.edgesoft.cn mailto:wangqi@edgesoft.cn ----------------------------------------------------