Обсуждение: Building new FreeBSD box - some assistance needed
I am building a new FreeBSD 6.1 box to migrate from the Windows PostgreSQL.
I am having some issues getting PostgreSQL to load when I try to duplicate my configuration as running on the Windows box.
I have made the modifications to loader.conf. All of the SHM values are being set properly (as I can see them in sysctl -a with the new values), but the sem values are not being updated.
I have limited the # of connections to bypass this minor problem, but would like to be able to bump it.
Do I need to rebuild the kernel for these values to take effect?
I'm setting my semaphores on FreeBSD/amd64 as follows:
$ more /boot/loader.conf
geom_mirror_load="YES"
kern.ipc.semmns=4096
kern.ipc.semmni=2048
machdep.hyperthreading_allowed=1
$
geom_mirror_load="YES"
kern.ipc.semmns=4096
kern.ipc.semmni=2048
machdep.hyperthreading_allowed=1
$
(the geom_mirror_load and machdep.hyperthreading_allowed are not relevant for this, but that's my entire
/boot/loader.conf file).
How may I help?
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Benjamin Krajmalnik
Sent: Monday, July 31, 2006 1:52 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Building new FreeBSD box - some assistance needed
I am building a new FreeBSD 6.1 box to migrate from the Windows PostgreSQL.
I am having some issues getting PostgreSQL to load when I try to duplicate my configuration as running on the Windows box.
I have made the modifications to loader.conf. All of the SHM values are being set properly (as I can see them in sysctl -a with the new values), but the sem values are not being updated.
I have limited the # of connections to bypass this minor problem, but would like to be able to bump it.
Do I need to rebuild the kernel for these values to take effect?