So the solution is to create a file /etc/sysctl.conf with the following: kern.sysv.shmmax=33554432 kern.sysv.shmmin=1 kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=65536
I went looking for my rc.conf and can not find it under os 10.5... Apple must have moved it again. If someone very knowledgeable can post where this file went (more for information than need) I would appreciate it. I assumed that since I had no problem installing postgresql on server 10.5.1 I would have the same luck on client..... When you assume.... Thanks, everything is beautiful now and I am back on track with webobjects... Ted --- Tom Lane <[EMAIL PROTECTED]> wrote: > Theodore Petrosky <[EMAIL PROTECTED]> writes: > > when I check the results/float4.out I see: > > psql: FATAL: sorry, too many clients already > > Hah. Check what initdb set max_connections to, and > run the tests > with fewer clients than that: > make MAX_CONNECTIONS=n check > > In the long run you'll want to increase the shared > memory settings > --- Apple's out-of-the-box defaults are pretty lame. > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will > ignore your desire to > choose an index scan if your joining column's > datatypes do not > match > ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend