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 B224E9DCAAE for ; Wed, 7 Dec 2005 14:04:31 -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 70322-08 for ; Wed, 7 Dec 2005 14:04:30 -0400 (AST) X-Greylist: delayed 11:53:27.787727 by SQLgrey- Received: from lcd.colorado.edu (lcd.colorado.edu [128.138.188.179]) by postgresql.org (Postfix) with ESMTP id A75B89DCCE0 for ; Wed, 7 Dec 2005 14:04:28 -0400 (AST) Received: from lcd (lcd [128.138.188.179]) by lcd.colorado.edu (8.12.10/8.12.10) with SMTP id jB7I4OUd000843; Wed, 7 Dec 2005 11:04:24 -0700 (MST) Message-Id: <200512071804.jB7I4OUd000843@lcd.colorado.edu> Date: Wed, 7 Dec 2005 11:04:24 -0700 (MST) From: "Anne M. Hammond" Reply-To: "Anne M. Hammond" Subject: Re: initdb fails To: pgsql-admin@postgresql.org Cc: pandurangan.r.s@gmail.com, tgl@sss.pgh.pa.us, hammond@solarz.Colorado.EDU MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii Content-MD5: ROcKO79Ei8Gixf0M+8IpiA== X-Mailer: dtmail 1.3.0 @(#)CDE Version 1.4.8 SunOS 5.8 sun4u sparc X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.666 required=5 tests=[AWL=0.666] X-Spam-Score: 0.666 X-Spam-Level: X-Archive-Number: 200512/54 X-Sequence-Number: 19774 Summary: I used a workstation where /usr/local/pgsql was mounted, and which had a larger SHMMAX. initdb worked there. Then I returned to the server, edited /usr/local/pgsql/data/pgsql.conf for smaller sizes than the default shared_buffers and max_connections. Thanks to Pandu and Tom Lane for the following links which describe in detail the various configuration options: http://www.powerpostgresql.com/Downloads/annotated_conf_80.html http://www.postgresql.org/docs/7.4/static/kernel-resources.html However, when the server SHMMAX is smaller than the size required by the defaults for shared_buffers and max_connections, I have not been able to find a way (other than the above), to tell initdb to use a nondefault values. If this is possible, it should be documented. The conf file is in the data directory--initdb will not init if there are existing files in that directory. I am doing this for a class where there initially will be only one connection; and it's not possible to reboot the server at this time. So I realize my solution is a suboptimal configuration, but would like to get it up and working. If there is another way to do this, such as command line options or environmental values for initdb, I haven't found it. Thanks for the help and suggestions. Anne 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=1, size=1081344, 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="shared_buffers = 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 >