X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9E2E840C179 for ; Mon, 31 Jan 2005 02:16:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97557-06 for ; Mon, 31 Jan 2005 02:15:50 +0000 (GMT) Received: from smtp-gw-cl-d.dmv.com (smtp-gw-cl-d.dmv.com [216.240.97.42]) by svr1.postgresql.org (Postfix) with ESMTP id 7822F40C276 for ; Mon, 31 Jan 2005 02:12:08 +0000 (GMT) Received: from mail-gw-cl-b.dmv.com (mail-gw-cl-b.dmv.com [216.240.97.39]) by smtp-gw-cl-d.dmv.com (8.12.10/8.12.10) with ESMTP id j0V2OJWa089188; Sun, 30 Jan 2005 21:24:19 -0500 (EST) (envelope-from sven@dmv.com) Received: from [64.45.134.154] (dogpound.dyndns.org [64.45.134.154]) by mail-gw-cl-b.dmv.com (8.12.9/8.12.9) with ESMTP id j0V2C8eE075272; Sun, 30 Jan 2005 21:12:09 -0500 (EST) (envelope-from sven@dmv.com) Message-ID: <41FD93F8.90507@dmv.com> Date: Sun, 30 Jan 2005 21:12:08 -0500 From: Sven Willenberger User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-general@postgresql.org Cc: Rick Apichairuk Subject: Re: FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings References: <9776bb66050130122122a3e342@mail.gmail.com> <20050130205021.GA14588@guests.deus.net> <9776bb660501301326565859a3@mail.gmail.com> <9a0c82c605013013555f92eee8@mail.gmail.com> <9776bb6605013015361b75cddf@mail.gmail.com> In-Reply-To: <9776bb6605013015361b75cddf@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.48 on 216.240.97.42 X-Scanned-By: MIMEDefang 2.48 on 216.240.97.39 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.296 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200501/1779 X-Sequence-Number: 72728 Rick Apichairuk wrote: > I tried the settings you gave and they worked (with some caveats). > > After I recompiled the FreeBSD kernel with the options: > > options SYSVSHM > options SYSVMSG > options SYSVSEM > > options SHMMAXPGS=131072 > options SEMMNI=128 > options SEMMNS=512 > options SEMUME=100 > options SEMMNU=256 > > I rebooted and attempted to start postgresql and it failed again. I > then ran sysctl -a to verify that the settings were correct. They were > not. Regardless of what's configured in the kernel conf file, the > default values were loaded. I assume you added these variables to either the GENERIC or a custom kernel in /usr/src/sys/i386/conf. If you created a custom kernel called CUSTOM, then you would: cd /usr/src make buildkernel KERNCONF=CUSTOM make installkernel KERNCONF=CUSTOM Just wanted to verify that you built and installed the kernel using the config file that has the settings you listed above (your sysctl output would indicate otherwise). Sven