From: Michael Bochkaryov <misha@rattler.kiev.ua> To: ALT Linux Community general discussions <community@lists.altlinux.org> Subject: Re: [Comm] Сборка Postgresql Date: Fri, 12 Sep 2008 18:03:11 +0300 Message-ID: <48CA84AF.4090309@rattler.kiev.ua> (raw) In-Reply-To: <20080911162650.0477fabe@notebook> 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
prev parent reply other threads:[~2008-09-12 15:03 UTC|newest] Thread overview: 10+ messages / expand[flat|nested] mbox.gz Atom feed top 2008-09-09 19:25 Denis S. Kostin 2008-09-09 20:36 ` Konstantin Pavlov 2008-09-09 21:01 ` Denis S. Kostin 2008-09-09 21:32 ` Vitaly Lipatov 2008-09-09 21:39 ` Denis S. Kostin 2008-09-10 4:30 ` Sergey Alembekov 2008-09-10 6:24 ` Алексей Шенцев 2008-09-10 6:48 ` Sergey Alembekov 2008-09-11 12:26 ` Alex Gorbachenko 2008-09-12 15:03 ` Michael Bochkaryov [this message]
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=48CA84AF.4090309@rattler.kiev.ua \ --to=misha@rattler.kiev.ua \ --cc=community@lists.altlinux.org \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
ALT Linux Community general discussions This inbox may be cloned and mirrored by anyone: git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git # If you have public-inbox 1.1+ installed, you may # initialize and index your mirror using the following commands: public-inbox-init -V2 community community/ http://lore.altlinux.org/community \ mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com public-inbox-index community Example config snippet for mirrors. Newsgroup available over NNTP: nntp://lore.altlinux.org/org.altlinux.lists.community AGPL code for this site: git clone https://public-inbox.org/public-inbox.git