From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <misha@rattler.kiev.ua>
X-Spam-Checker-Version: SpamAssassin 3.2.4 (2008-01-01) on sa.int.altlinux.org
X-Spam-Level: 
X-Spam-Status: No, score=-2.6 required=5.0 tests=BAYES_00 autolearn=ham
	version=3.2.4
Message-ID: <48CA84AF.4090309@rattler.kiev.ua>
Date: Fri, 12 Sep 2008 18:03:11 +0300
From: Michael Bochkaryov <misha@rattler.kiev.ua>
User-Agent: Thunderbird 2.0.0.14 (X11/20080513)
MIME-Version: 1.0
To: ALT Linux Community general discussions <community@lists.altlinux.org>
References: <354375841.20080909232533@3436.ru>
	<20080911162650.0477fabe@notebook>
In-Reply-To: <20080911162650.0477fabe@notebook>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: [Comm] =?koi8-r?b?88LP0svBIFBvc3RncmVzcWw=?=
X-BeenThere: community@lists.altlinux.org
X-Mailman-Version: 2.1.10b3
Precedence: list
Reply-To: ALT Linux Community general discussions
	<community@lists.altlinux.org>
List-Id: ALT Linux Community general discussions <community.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/listinfo/community>,
	<mailto:community-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/community>
List-Post: <mailto:community@lists.altlinux.org>
List-Help: <mailto:community-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/community>,
	<mailto:community-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Fri, 12 Sep 2008 14:55:50 -0000
Archived-At: <http://lore.altlinux.org/community/48CA84AF.4090309@rattler.kiev.ua/>
List-Archive: <http://lore.altlinux.org/community/>
List-Post: <mailto:mandrake-russian@linuxteam.iplabs.ru>

Alex Gorbachenko пишет:
> On Tue, 9 Sep 2008 23:25:33 +0400
> Denis wrote:
> 
>> HINT:  This error usually means that PostgreSQL's request for a shared
>> memory segment exceeded your kernel's SHMMAX parameter.  You can
>> either reduce the req uest size or reconfigure the kernel with larger
>> SHMMAX.  To reduce the request size (currently 34086912 bytes), reduce
>> PostgreSQL's shared_buffers parameter (currently 3072) and/or its
>> max_connections parameter (currently 103).
>>        If the request size is already small, it's possible that it is
>> less than your kernel's SHMMIN parameter, in which case raising the
>> request size or re
>> configuring SHMMIN is called for.
> 
> какие слова перевести ? поцгрецу при сборке не хватает шареной памяти.
> обойти это можно двумя способами, и оба описаны выше, в квоте.

многабукав? :)))

> 1. увеличить значения kernel.shmmax и kernel.shmall в /etc/sysctl.conf;

Если использовать на этой же системе - лучше так и сделать.
Увеличение доступной разделяемой памяти редко вредит постгресу.

Да и разово вызвать sysctl -w kernel.shmmax=134217728 проще

> 2. уменьшить значение shared_buffers в конфиге, с которым запускается
> регресс-тест. 

Если только ради единичной сборки - лишний гемор, JIMHO.

-- 
Michael Bochkaryov