Re: [GENERAL] PostgreSQL vs FreeBSD 7.0 as regular user

[Ivan Voras]

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."

sysctl -w a.b=c

is 100% equivalent to

sysctl a.b=c

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

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 :)

signature.asc
Description: OpenPGP digital signature