Scott,
Thank you.
Just add them to the bottom then run
sudo sysctl -p
to make them take effect.
It seems that if this value is greater than RAM, linux kerner silently uses
max possible value.
Linuxes are used mostly to run PostgreSql only but ram may vary depending on
virtual maschine configuration at runtime.
Is it reasonable to use large value, eq. 8GB as SHMMAX in sysctl.conf file
always ?
In this case root and SSH access to server is not required if RAM amount
changes. This simplifies server administration. Only postgresql.conf needs
changed which can be done from 5432 port using pgAdmin.
btw, the standard way to control rc stuff is update-rc.d Odd name but
it's pretty easy, just look up the man page.
Debian seems to require update-rc.d and Centos chkconfig
How to use single command for every distro ?
"/etc/init.d/postgresql start" works in all distros. Adding to postgresql to
startup requires different commands in different distros ?!
Andrus
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
