| From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
|---|---|
| To: | Zoltan Boszormenyi <zb(at)cybertec(dot)at> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, lists(at)stringsutils(dot)com, pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL vs FreeBSD 7.0 as regular user |
| Date: | 2008-07-26 21:23:11 |
| Message-ID: | Pine.GSO.4.64.0807261714200.29072@westnet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | aravind chandu | 2008-07-26 21:32:05 | procedure to load xml file data in postgesql |
| Previous Message | Andrej Ricnik-Bay | 2008-07-26 20:53:09 | Re: Problems Restarting PostgreSQL Daemon |