X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 35D689DCABF for ; Wed, 7 Dec 2005 10:35:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09620-09 for ; Wed, 7 Dec 2005 10:35:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 44B7E9DCAAF for ; Wed, 7 Dec 2005 10:35:15 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jB7EZJ9G028801; Wed, 7 Dec 2005 09:35:19 -0500 (EST) To: "Anne M. Hammond" cc: pgsql-admin@postgresql.org Subject: Re: initdb fails In-reply-to: References: Comments: In-reply-to "Anne M. Hammond" message dated "Tue, 06 Dec 2005 23:10:57 -0700" Date: Wed, 07 Dec 2005 09:35:19 -0500 Message-ID: <28800.1133966119@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.002 required=5 tests=[AWL=0.002] X-Spam-Score: 0.002 X-Spam-Level: X-Archive-Number: 200512/51 X-Sequence-Number: 19771 "Anne M. Hammond" writes: > So the shared memory request is greater than the SHMMAX in > the kernel. If I just wanted to use a smaller number of shared_buffers > (24), I tried editing /usr/local/pgsql/data/pgsql.conf. You're going to have to increase SHMMAX anyway, so you might as well just do that, rather than trying to outflank initdb. PG's performance with any less than several hundred shared buffers is just too awful to consider using. I haven't done this on Solaris personally, but according to our docs http://www.postgresql.org/docs/7.4/static/kernel-resources.html it's just a matter of editing /etc/system and rebooting. regards, tom lane