From: Larry Rosenman <ler@lerctr.org>
To: 'Benjamin Krajmalnik' <kraj@illumen.com>
To: pgsql-admin@postgresql.org
Subject: Re: Building new FreeBSD box - some assistance needed
Date: Mon, 31 Jul 2006 13:57:53 -0500
Message-ID: <008f01c6b4d3$3a6d5260$aa0610ac@aus.pervasive.com> (raw)
In-Reply-To: <BF337097BDD9D849A2F4B818DDB279870294E0@stash.stackdump.local>
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
$
(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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: ler@lerctr.org, kraj@illumen.com
Subject: Re: Building new FreeBSD box - some assistance needed
In-Reply-To: <008f01c6b4d3$3a6d5260$aa0610ac@aus.pervasive.com>
References: <BF337097BDD9D849A2F4B818DDB279870294E0@stash.stackdump.local> <008f01c6b4d3$3a6d5260$aa0610ac@aus.pervasive.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox