X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D161C9FB359 for ; Mon, 31 Jul 2006 15:58:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 19935-01 for ; Mon, 31 Jul 2006 15:57:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from thebighonker.lerctr.org (thebighonker.lerctr.org [192.147.25.65]) by postgresql.org (Postfix) with ESMTP id E76BB9FB332 for ; Mon, 31 Jul 2006 15:57:57 -0300 (ADT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=lerami; d=lerctr.org; b=Sn8Mf7DGnBgAT3FLTU6le5YuphX395q2GqeonT68X74REoW4vgUXEbF1L+RyB7weH7VcUOmIz2QaBqiz7Pu5kHksWJuR23LtIjIbsalDx30yUP966gHj8G4hoH5M3amCtYJuTupkJzKBzXDMQQqlr/fX6cr2hRd6V6ykW4gKO5w=; Received: from 64-132-13-2.static.twtelecom.net ([64.132.13.2]:60135 helo=LROSENMAC8010P) by thebighonker.lerctr.org with esmtpsa (TLSv1:RC4-MD5:128) (Exim 4.62 (FreeBSD)) (envelope-from ) id 1G7cxd-0007pL-TC; Mon, 31 Jul 2006 13:57:55 -0500 From: "Larry Rosenman" To: "'Benjamin Krajmalnik'" , 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> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0090_01C6B4A9.51974A60" X-Mailer: Microsoft Office Outlook 11 In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 thread-index: Aca0ytnRWAOePhqEQ1m58j2SOTfBzgAACgSwAAAoxoAAAdlwAA== X-LERCTR-Spam-Score: -4.3 (----) X-LERCTR-Spam-Report: (-4.3 points, 5.0 required) ALL_TRUSTED=-1.8 BAYES_00=-2.599 HTML_MESSAGE=0.001 TW_PG=0.077 DomainKey-Status: no signature X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200607/298 X-Sequence-Number: 22544 This is a multi-part message in MIME format. ------=_NextPart_000_0090_01C6B4A9.51974A60 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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? ------=_NextPart_000_0090_01C6B4A9.51974A60 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
I'm setting my semaphores on FreeBSD/amd64 as=20 follows:
$ more=20 /boot/loader.conf
geom_mirror_load=3D"YES"
kern.ipc.semmns=3D4096kern.ipc.semmni=3D2048
machdep.hyperthreading_allowed=3D1
$
(the geom_mirror_load and = machdep.hyperthreading_allowed=20 are not relevant for this, but that's my entire
/boot/loader.conf file).
 
How may I help?
 
LER
 

--
Larry=20 Rosenman           = ;         =20 http://www.lerctr.org/~ler
Pho= ne: +1=20 512-248-2683          &= nbsp;     =20 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX=20 78681-3893

 


From: = pgsql-admin-owner@postgresql.org=20 [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Benjamin=20 Krajmalnik
Sent: Monday, July 31, 2006 1:52 PM
To:=20 pgsql-admin@postgresql.org
Subject: [ADMIN] Building new = FreeBSD box -=20 some assistance needed

I am building a new FreeBSD 6.1 box to migrate = from the=20 Windows PostgreSQL.
I am having some issues getting PostgreSQL to = load when I=20 try to duplicate my configuration as running on the Windows=20 box.
 
I have made the modifications to = loader.conf.  All of=20 the SHM values are being set properly (as I can see them in sysctl -a = with the=20 new values), but the sem values are not being = updated.
I have limited the # of connections to bypass = this minor=20 problem, but would like to be able to bump it.
 
Do I need to rebuild the kernel for these = values to take=20 effect?
------=_NextPart_000_0090_01C6B4A9.51974A60--