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
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 |
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 |