pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed7.4.1 install problems on OS X 10.3
3+ messages / 3 participants
[nested] [flat]
* 7.4.1 install problems on OS X 10.3
@ 2003-12-29 20:48 beyaRecords - The home Urban music <uzo@beya-records.com>
0 siblings, 2 replies; 3+ messages in thread
From: beyaRecords - The home Urban music @ 2003-12-29 20:48 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] 7.4.1 install problems on OS X 10.3
@ 2003-12-29 22:05 Theodore Petrosky <tedpet5@yahoo.com>
parent: beyaRecords - The home Urban music <uzo@beya-records.com>
1 sibling, 0 replies; 3+ messages in thread
From: Theodore Petrosky @ 2003-12-29 22:05 UTC (permalink / raw)
To: beyaRecords - The home Urban music <uzo@beya-records.com>; pgsql -bugs <pgsql-bugs@postgresql.org>
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 7.4.1 install problems on OS X 10.3
@ 2003-12-29 23:00 Tom Lane <tgl@sss.pgh.pa.us>
parent: beyaRecords - The home Urban music <uzo@beya-records.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2003-12-29 23:00 UTC (permalink / raw)
To: beyaRecords - The home Urban music <uzo@beya-records.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-12-29 23:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-29 20:48 7.4.1 install problems on OS X 10.3 beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-29 22:05 ` Theodore Petrosky <tedpet5@yahoo.com>
2003-12-29 23:00 ` Tom Lane <tgl@sss.pgh.pa.us>
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