Re: PostgreSQL vs FreeBSD 7.0 as regular user

Greg Smith wrote:
> On Sat, 26 Jul 2008, Zoltan Boszormenyi wrote:
>
>> Zoltan Boszormenyi �rta:
>>>>> These three settings were also set with "sysctl -w ..." to take effect
>>>>> immediately.
>> Rebooting FreeBSD solved it. Huh? Is it really like W#&@$#&?
>
> Looks like the PostgreSQL documentation here (
> http://www.postgresql.org/docs/current/static/kernel-resources.html ) is
> now outdated. From http://www.manpages.info/freebsd/sysctl.8.html :
>
> "The -w option has been deprecated and is silently ignored."

It's not ignored as in "the whole command will have no effect". Only the
switch itself is ignored. So,

sysctl -w a.b=c

is 100% equivalent to

sysctl a.b=c

> Looks like the correct thing to do here now is to edit the
> /etc/sysctl.conf file, then issue:
>
> /etc/rc.d/sysctl reload
>
> to use those values without needing to reboot. (I don't actually have
> such a machine to check for sure).

Yes, that will work. Sysctl.conf will not reload itself :)