SEO

I attempted to install 8.0 RC 2 alongside 7.4.5 on my OS X box, but
initdb failed with an error about not enough shared memory.

Remembering that this was a problem for starting two postmasters at the
same time on OS X, I increased the shmmax value to 500 megabytes (I had
seen something say raising it to half the available ram would be fine),
but when I rebooted my machine neither 8.0 or 7.4.5 would start.

So I lowered it to 256 megabytes, thinking there might be an upper limit
on that kind of stuff. When I rebooted my machine, 7.4.5 starts fine,
but 8.0 still will not start alongside it.

I don't particularly need both postmasters running at the same time, but
I would like to figure out the solution to this problem.

(By the way, in the course of this I attempted to manually run /etc/rc
.... there were humorous results and my computer didn't really like it:
http://www.visualdistortion.org/misc/dont_do_this.png)

Jeffrey Melloy
jmelloy@visualdistortion.org

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Jeffrey Melloy <jmelloy@visualdistortion.org> writes:
> I attempted to install 8.0 RC 2 alongside 7.4.5 on my OS X box, but
> initdb failed with an error about not enough shared memory.

Don't forget that both shmmax and shmall may need attention ... and,
just to confuse matters, they are measured in different units.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

What version of OS X?

Apparently some of the earlier versions did not permit changing this
parameter without recompiling the kernel. It seems to have been
changed in the more recent versions, though:

http://www.opendarwin.org/pipermail/...st/003583.html
http://borkware.com/rants/openacs/
http://www.ssec.wisc.edu/mug/users_g...redMemory.html

A note from that last URL is that shmall*4096=shmmax.

And yes, trying to manually run an rc script is a bad idea.

On Dec 22, 2004, at 3:44 PM, Jeffrey Melloy wrote:

> I attempted to install 8.0 RC 2 alongside 7.4.5 on my OS X box, but
> initdb failed with an error about not enough shared memory.
>
> Remembering that this was a problem for starting two postmasters at
> the same time on OS X, I increased the shmmax value to 500 megabytes
> (I had seen something say raising it to half the available ram would
> be fine), but when I rebooted my machine neither 8.0 or 7.4.5 would
> start.
>
> So I lowered it to 256 megabytes, thinking there might be an upper
> limit on that kind of stuff. When I rebooted my machine, 7.4.5 starts
> fine, but 8.0 still will not start alongside it.
>
> I don't particularly need both postmasters running at the same time,
> but I would like to figure out the solution to this problem.
>
> (By the way, in the course of this I attempted to manually run /etc/rc
> ... there were humorous results and my computer didn't really like it:
> http://www.visualdistortion.org/misc/dont_do_this.png)
>
> Jeffrey Melloy
> jmelloy@visualdistortion.org
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
-----------------------------------------------------------
Frank D. Engel, Jr. <fde101@fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFByeRp7aqtWrR9cZoRAjJDAJ9znykbsbT9UvAFiHCOUW Ch5PHywACeJsCG
qjUCBeWZL9oYSb6pn6eYCKg=
=DOAg
-----END PGP SIGNATURE-----

Tom Lane wrote:

>Jeffrey Melloy <jmelloy@visualdistortion.org> writes:
>
>
>>I attempted to install 8.0 RC 2 alongside 7.4.5 on my OS X box, but
>>initdb failed with an error about not enough shared memory.
>>
>>
>
>Don't forget that both shmmax and shmall may need attention ... and,
>just to confuse matters, they are measured in different units.
>
> regards, tom lane
>
>
I didn't realize that they were different units. Setting shmmax to
268435456 and shmall to 65536 works fine.

Thanks,
Jeff

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match