Entropy.ch Discussion Forums

[liyanage]

It seems that on Panther some changes to a system configuration file are required. I found this information at http://borkware.com/quickies/one?topic=Unix .

In the file /etc/rc, look for lines similar to the following and adjust the values accordingly:

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

Save and reboot the machine.

[goynang]

I've got your postgres.pkg running on my copy of panther and haven't noticed any problems - although I haven't tested that much yet.

My motto tends to be "If it ain't broke don't fix it" - so I'd like to know what effects I'm likely to see by not making this change - what will go wrong?

Cheers.

[liyanage]

Interesting... Clearly, if it works for you, don't mess with these settings.
On my machine, it wouldn't even start up, with corresponding error messages in the log file.

[markd]

Yeah, you'll need to add those if you have any configuration parameters that increase the shared memory usage, like shared_buffers. In general, upping those kernel parameters won't harm anything - they're just limits to what programs can allocate. By giving yourself a lot of headroom, you can play around with configuration tuning of the database without a lot of hassle.

Glad our quickies were of use to you.
_________________
co-author of Core Mac OS X and Unix Programming

[liyanage]

Hi Mark

Yeah, they quickies look *extremely* useful.

Didn't realize who you are or whose website it is, I saw your book presented at WWDC

[markd]

Excellent! I hope I didn't make too much of a fool of myself :-) I got a bit punchy in the booth by wednesday.
_________________
co-author of Core Mac OS X and Unix Programming

[Paulatre]

on previous version of your installer I couldn't get the PLpgSQL language to run, was giving me a an .so object file error, had finally to fix it manually and recompile the whole package again...
has it been fixed in this version?

[liyanage]

hmm no idea... You could try it and let us know here

[ejoe]

Hi Mark, all,

We met at WWDC, I was the guy who hassled you by IRC for help one time about MySQL under 10.1.5 (or some similar silly reason) when I was at my wit's end (which isn't necessarily hard to get to...)

Anyway, I thought I'd chime in to say that it looks like it is working just fine under Build 7C107.

Thanks! Now if you could just make an easy installer for GRASS with MapServer support!

Thanks for all your incredible efforts to bring great OSS to MacOSX!!!

Joe Pezzillo
Boulder, Colorado USA

[ejoe]

Just to clarify, PostgreSQL is working fine under Panther...

[fugaz]

[jeffs]

I found that enabling network connectivity was just a matter of editing a file and restarting

1) become superuser and open the file /usr/local/pgsql/data/postgresql.conf in an editor (like vi)

2) find the line (near the beginning) which reads:

#tcpip_socket = false

3) uncomment it by removing the leading "#"

4) change "false" to "true" so the line looks like this:

tcpip_socket = true

5) save the file and restart

jeffs

[johnb]

[keath]

SystemTuning is basically an empty file on my system also. It looks like this:

[johnb]