Re: Building new FreeBSD box - some assistance needed

From: "Larry Rosenman" <ler(at)lerctr(dot)org>
To: "'Benjamin Krajmalnik'" <kraj(at)illumen(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Building new FreeBSD box - some assistance needed
Date: 2006-07-31 18:57:53
Message-ID: 008f01c6b4d3$3a6d5260$aa0610ac@aus.pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

_____

From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Benjamin Krajmalnik
Sent: Monday, July 31, 2006 1:52 PM
To: pgsql-admin(at)postgresql(dot)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?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dilipkumar 2006-08-01 03:29:02 Re: PostgreSQL hanging
Previous Message Benjamin Krajmalnik 2006-07-31 18:52:14 Building new FreeBSD box - some assistance needed