X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7C703D1B4D3 for ; Mon, 29 Dec 2003 22:08:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 92828-07 for ; Mon, 29 Dec 2003 18:07:19 -0400 (AST) Received: from web41013.mail.yahoo.com (web41013.mail.yahoo.com [66.218.93.12]) by svr1.postgresql.org (Postfix) with SMTP id 2304CD1B436 for ; Mon, 29 Dec 2003 18:05:41 -0400 (AST) Message-ID: <20031229220542.8397.qmail@web41013.mail.yahoo.com> Received: from [207.98.193.213] by web41013.mail.yahoo.com via HTTP; Mon, 29 Dec 2003 14:05:42 PST Date: Mon, 29 Dec 2003 14:05:42 -0800 (PST) From: Theodore Petrosky Subject: Re: [SQL] 7.4.1 install problems on OS X 10.3 To: beyaRecords - The home Urban music , pgsql -bugs In-Reply-To: <5D32E76C-3A40-11D8-BD9C-0003938366A4@beya-records.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/292 X-Sequence-Number: 7569 you will have to edit the file called 'rc' in the top level etc folder.. in the terminal type cd /etc sudo pico rc (you will be asked for an administrator password) scroll down 2 to 3 pages and find the section like this # System tuning sysctl -w kern.maxvnodes=$(echo $(sysctl -n hw.physmem) '33554432 / 512 * 1024 +p'|dc) sysctl -w kern.sysv.shmmax=167772160 sysctl -w kern.sysv.shmmin=1 sysctl -w kern.sysv.shmmni=32 sysctl -w kern.sysv.shmseg=8 sysctl -w kern.sysv.shmall=65536 after you change the values to look like this, type a control-x to save and exit. restart your machine. these are the values that I used and they work. I don't know if these are the best settings, only that they work.. Ted --- beyaRecords - The home Urban music wrote: > Hi, > I have been forced to re-buid postgresql 7.4.1 but > am encountering a > problem when i do the following: > > 1. /usr/local/pgsql/bin/initdb -D > /usr/local/pgsql/data > > the error I get is as follows: > > fixing permissions on existing directory > /usr/local/pgsql/data... ok > creating directory /usr/local/pgsql/data/base... ok > creating directory /usr/local/pgsql/data/global... > ok > creating directory /usr/local/pgsql/data/pg_xlog... > ok > creating directory /usr/local/pgsql/data/pg_clog... > ok > 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: Cannot > allocate memory > DETAIL: Failed system call was shmget(key=1, > size=1081344, 03600). > HINT: This error usually means that PostgreSQL's > request for a shared > memory segment exceeded available memory or swap > space. To reduce the > request size (currently 1081344 bytes), reduce > PostgreSQL's > shared_buffers parameter (currently 50) and/or its > max_connections > parameter (currently 10). > The PostgreSQL documentation contains more > information about > shared memory configuration. > > initdb: failed > > Any ideas as to how I can rectify this, taking into > consideration that > I am a complete novice in the wonderful world of > unix ;-) > > > regards > > > Uzo > > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings __________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/