From: Theodore Petrosky <tedpet5@yahoo.com>
To: beyaRecords - The home Urban music <uzo@beya-records.com>
To: pgsql -bugs <pgsql-bugs@postgresql.org>
Subject: Re: [SQL] 7.4.1 install problems on OS X 10.3
Date: Mon, 29 Dec 2003 14:05:42 -0800 (PST)
Message-ID: <20031229220542.8397.qmail@web41013.mail.yahoo.com> (raw)
In-Reply-To: <5D32E76C-3A40-11D8-BD9C-0003938366A4@beya-records.com>
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
<uzo@beya-records.com> 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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tedpet5@yahoo.com, uzo@beya-records.com, pgsql-bugs@postgresql.org
Subject: Re: [SQL] 7.4.1 install problems on OS X 10.3
In-Reply-To: <20031229220542.8397.qmail@web41013.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox