7.4.1 install problems on OS X 10.3

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/

beyaRecords - The home Urban music <uzo@beya-records.com> writes:

I have been forced to re-buid postgresql 7.4.1 but am encountering a
problem when i do the following:

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).

You're out of shared memory. Did you shut down the old postmaster
before trying this? The default shared memory size on OS X is not large
enough to run more than one postmaster at a time (unless you reduce
7.4's default shared_buffers and max_connections quite a bit).

If you didn't shut down the old postmaster cleanly (eg you did kill -9
or some such) then the old shared memory segment may still be hanging
around even though it's not in use. OS X doesn't seem to have ipcs or
ipcrm, so there's no real easy way to check this, and no way to get rid
of such a segment except to reboot :-(.

regards, tom lane