[GENERAL] Memory Errors OS X

2004-12-22 Thread Jeffrey Melloy
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
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly


Re: [GENERAL] Memory Errors OS X

2004-12-22 Thread Tom Lane
Jeffrey Melloy [EMAIL PROTECTED] 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 [EMAIL PROTECTED]


Re: [GENERAL] Memory Errors OS X

2004-12-22 Thread Frank D. Engel, Jr.
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/hackers/2002-August/003583.html
http://borkware.com/rants/openacs/
http://www.ssec.wisc.edu/mug/users_guide/SharedMemory.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
[EMAIL PROTECTED]

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly


---
Frank D. Engel, Jr.  [EMAIL PROTECTED]>

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


PGP.sig
Description: This is a digitally signed message part


Re: [GENERAL] Memory Errors OS X

2004-12-22 Thread Jeffrey Melloy
Tom Lane wrote:
Jeffrey Melloy [EMAIL PROTECTED] 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