Re: How to install latest stable postgresql on Debian

2011/11/19 Andrus <kobruleht2(at)hot(dot)ee>:
>> From here(look familiar):
>> http://wiki.postgresql.org/wiki/Performance_Optimization
>> http://linuxfinances.info/info/quickstart.html
>> http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm
>
> Thank you.
> I tried
>
> # sysctl -w kernel.shmmax=419430400
> kernel.shmmax = 419430400
> # sysctl -n kernel.shmmax
> 419430400
>
> according to
> http://www.postgresql.org/docs/current/static/kernel-resources.html
> this value should be written to /etc/sysctl.conf
>
> I opened /etc/sysctl.conf but it does not contain this value.
>
> How to make this setting persistent ?

Just add them to the bottom then run

sudo sysctl -p

to make them take effect.

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.