Re: PostgreSQL vs FreeBSD 7.0 as regular user

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: PostgreSQL vs FreeBSD 7.0 as regular user
Дата
Msg-id Pine.GSO.4.64.0807261714200.29072@westnet.com
обсуждение исходный текст
Ответ на Re: PostgreSQL vs FreeBSD 7.0 as regular user  (Zoltan Boszormenyi <zb@cybertec.at>)
Ответы Re: PostgreSQL vs FreeBSD 7.0 as regular user  (Ivan Voras <ivoras@freebsd.org>)
Список pgsql-general
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."

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

Any FreeBSD users want to figure out when this changed (a quick check
suggests 4.4 may have been the one), confirm this is the right thing to do
now, and generate a doc patch?

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

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

Предыдущее
От: "Andrej Ricnik-Bay"
Дата:
Сообщение: Re: Problems Restarting PostgreSQL Daemon
Следующее
От: aravind chandu
Дата:
Сообщение: procedure to load xml file data in postgesql