Re: FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings

From: Sven Willenberger <sven(at)dmv(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Rick Apichairuk <rapichai(at)gmail(dot)com>
Subject: Re: FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings
Date: 2005-01-31 02:12:08
Message-ID: 41FD93F8.90507@dmv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rick Apichairuk 2005-01-31 02:28:38 Re: FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings
Previous Message Rick Apichairuk 2005-01-30 23:36:54 Re: FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings

Browse pgsql-general by date

  From Date Subject
Next Message Rick Schumeyer 2005-01-31 02:24:04 postgres session termination
Previous Message Frans 2005-01-31 01:28:28 postgresql 7.4.6 slowing down