Re: PostgreSQL vs FreeBSD 7.0 as regular user - Mailing list pgsql-general

From Greg Smith
Subject Re: PostgreSQL vs FreeBSD 7.0 as regular user
Date
Msg-id Pine.GSO.4.64.0807261714200.29072@westnet.com
Whole thread Raw
In response to Re: PostgreSQL vs FreeBSD 7.0 as regular user  (Zoltan Boszormenyi <zb@cybertec.at>)
Responses Re: PostgreSQL vs FreeBSD 7.0 as regular user
List 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 by date:

Previous
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Problems Restarting PostgreSQL Daemon
Next
From: aravind chandu
Date:
Subject: procedure to load xml file data in postgesql