PostgreSQL shared memory
// description of your code here
PostgreSQL 8.1.x/8.2.x works nicely on Leopard but you do have to alter some system settings.
In Mac OS X 10.3 and up you have to increase the shared memory of your system to be able to run PostgreSQL with more connections and be faster in general.
You had to go into /etc/rc and look for similar lines and changing the values accordingly
But in Leopard /etc/rc doesn't exist anymore. You now have to create or open /etc/sysctl.conf
Add the following lines to it:=
PostgreSQL 8.1.x/8.2.x works nicely on Leopard but you do have to alter some system settings.
In Mac OS X 10.3 and up you have to increase the shared memory of your system to be able to run PostgreSQL with more connections and be faster in general.
You had to go into /etc/rc and look for similar lines and changing 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
But in Leopard /etc/rc doesn't exist anymore. You now have to create or open /etc/sysctl.conf
Add the following lines to it:=
kern.sysv.shmmax=167772160 kern.sysv.shmmin=1 kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=65536