This is an obscure issue that only affects PostgreSQL installations on OS X. Apparently it prevents iChat video (with iSight, for example) from working. See following.
I tried finding where the best place to insert a patch would be in the CVS'd files, but my PostgreSQL-Tools-for-MacOS-X-fu is not up to snuff these days. I couldn't figure out where in the install phase postgresql.conf is being generated so I could insert some lines to call sed and modify the defaults.
In any case, I'm not sure decreasing the shared memory parameter in PostgreSQL is necessarily the "right" way to handle this issue because it might impact people who depend upon a robust PostgreSQL configuration on OS X, but bumping up OS X's shared memory parameter might be problematic when applied to any machine that installs this packaging of PostgreSQL. Note also that some people have also said that the iChat port conflicts with the PostgreSQL port; that wasn't what I experienced, but your mileage may vary.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There is no 'right' solution here. I actually opened a ticket with Apple on this very issue, because I feel that the default setting is too low.
The place to modify this is in /Library/PostgreSQL8/data/postgresql.conf. The installer doesn't do this, as it deviates from the defaults created by PostgreSQL's initdb call, though it is something that will be in the GUI for configuring PostgreSQL that I've just started working on.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is an obscure issue that only affects PostgreSQL installations on OS X. Apparently it prevents iChat video (with iSight, for example) from working. See following.
http://blog.erdener.org/archives/000726.php
http://www.murraywilliams.com/blog/archives/000046.html
http://archives.postgresql.org/pgsql-hackers/2005-08/msg01087.php
I tried finding where the best place to insert a patch would be in the CVS'd files, but my PostgreSQL-Tools-for-MacOS-X-fu is not up to snuff these days. I couldn't figure out where in the install phase postgresql.conf is being generated so I could insert some lines to call sed and modify the defaults.
In any case, I'm not sure decreasing the shared memory parameter in PostgreSQL is necessarily the "right" way to handle this issue because it might impact people who depend upon a robust PostgreSQL configuration on OS X, but bumping up OS X's shared memory parameter might be problematic when applied to any machine that installs this packaging of PostgreSQL. Note also that some people have also said that the iChat port conflicts with the PostgreSQL port; that wasn't what I experienced, but your mileage may vary.
There is no 'right' solution here. I actually opened a ticket with Apple on this very issue, because I feel that the default setting is too low.
The place to modify this is in /Library/PostgreSQL8/data/postgresql.conf. The installer doesn't do this, as it deviates from the defaults created by PostgreSQL's initdb call, though it is something that will be in the GUI for configuring PostgreSQL that I've just started working on.