Re: PostgreSQL vs FreeBSD 7.0 as regular user

Поиск
Список
Период
Сортировка
От Ivan Voras
Тема Re: PostgreSQL vs FreeBSD 7.0 as regular user
Дата
Msg-id g6ghpp$a7m$2@ger.gmane.org
обсуждение исходный текст
Ответ на Re: PostgreSQL vs FreeBSD 7.0 as regular user  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-general
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 :)



Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Andrej Ricnik-Bay"
Дата:
Сообщение: Re: Problems Restarting PostgreSQL Daemon
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: Problems Restarting PostgreSQL Daemon