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 837F39DD079 for ; Wed, 7 Dec 2005 05:19:27 -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 37645-08 for ; Wed, 7 Dec 2005 05:19:28 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.207]) by postgresql.org (Postfix) with ESMTP id 209ED9DD06C for ; Wed, 7 Dec 2005 05:19:24 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 34so293429nzf for ; Wed, 07 Dec 2005 01:19:26 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=igjhnPQx4/MTOQdpJka/BgTGhrOLUzUjqIjWWOeMLVJmwKWeprE1+KWdL84G9y21dERyfqEdlvrmfR9LtLAZZg8TMlMaMju9N/Qtox361VEr7SI6+LNJvq8wGe/VAs9jxwW1P8AkpIoz+MuD6xu+s5xrRGLLC3itKeKGNePB5vA= Received: by 10.65.20.13 with SMTP id x13mr1608141qbi; Wed, 07 Dec 2005 01:19:26 -0800 (PST) Received: by 10.64.209.2 with HTTP; Wed, 7 Dec 2005 01:19:26 -0800 (PST) Message-ID: <5e744e3d0512070119l6fb52eaao765d54277838f62f@mail.gmail.com> Date: Wed, 7 Dec 2005 14:49:26 +0530 From: Pandurangan R S To: "Anne M. Hammond" Subject: Re: initdb fails Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.046 required=5 tests=[AWL=0.046] X-Spam-Score: 0.046 X-Spam-Level: X-Archive-Number: 200512/45 X-Sequence-Number: 19765 Hi, The following link will help you http://www.powerpostgresql.com/Downloads/annotated_conf_80.html On 12/7/05, Anne M. Hammond wrote: > This is running on a Solaris 8 machine. > > I installed V 7.4.7 to use with OpenACS. > > lcd[34]% /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data > ... > selecting default max_connections... 10 > selecting default shared_buffers... 50 > creating configuration files... ok > creating template1 database in /usr/local/pgsql/data/base/1... FATAL: > could not create shared memory segment: Invalid argument > DETAIL: Failed system call was shmget(key=3D1, size=3D1081344, 03600). > ... > > lcd[36]% sysdef -i | grep SHMMAX > 1048576 max shared memory segment size (SHMMAX) > > ----------- > 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. > > But initdb -D /usr/local/pgsql/data > finds that the directory is not empty and will not create the databases. > I have also tried > setenv PGOPTIONS=3D"shared_buffers =3D 24" > and tried initdb, but initdb uses the default number. > > Could you tell me how to set shared_buffers from the default so > that a smaller shared memory segment will be requested? > > If you could also tell me how to set the max_connections to a value > different from the default, that would be great. > > Any advice appreciated. > > Anne Hammond, University of Colorado at Boulder > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- Regards Pandu