Message-ID: <533981FD.10906@aklaver.com>
Date: Mon, 31 Mar 2014 07:55:57 -0700
From: Adrian Klaver <adrian.klaver@aklaver.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:24.0) Gecko/20100101 Thunderbird/24.4.0
MIME-Version: 1.0
To: Willy-Bas Loos <willybas@gmail.com>
CC: lst_hoe02@kwsoft.de, pgsql-admin <pgsql-admin@postgresql.org>,
 "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: [ADMIN]openvz and shared memory trouble
References: 
 <CAHnozTjxUrfbaZVFbzibLQmhzR-n9ty+ktyRN2a0Tyr9PhApqQ@mail.gmail.com>
	<53357E83.2040101@aklaver.com>
	<CAHnozThQ9WkE+b3b1kXGpgNfnpP6NsxpFNSmvgsw_ZnqGfc+CA@mail.gmail.com>
	<53370026.2040509@aklaver.com>
 <CAHnozTjVQeisMGKPsPMbYJ=_jqBNNvZ81x0ohRuta364J9cdmg@mail.gmail.com>
In-Reply-To: 
 <CAHnozTjVQeisMGKPsPMbYJ=_jqBNNvZ81x0ohRuta364J9cdmg@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

On 03/31/2014 04:12 AM, Willy-Bas Loos wrote:
>
> On Sat, Mar 29, 2014 at 6:17 PM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:

>
> And it makes me wonder what else may be issues that arise from that. But
> especially, what i can do about it.

Had to go through it a couple of times, and look up the acronyms, but 
the thread below seems to deal with the whole shared memory allocation 
and setting process in openvz quite well:

http://forum.openvz.org/index.php?t=msg&goto=12061&&srch=postgresql+shared#msg_12061

In particular, where UBC is User Beancounters and the sysctls is the one 
in the container.:

"UBC shmpages parameter controls all the shared memory which possible to 
allocate
either via IPC or shmem (e.g. tmpfs).

sysctls above are only for IPC SYSv5 shared memory."

combine that with, where VE is Vitual Environment(container):

"check the same in VE please.
AFAICS, by default kernel sets:
#define SHMMAX 0x2000000
which is 32Mb.
So you have to increase it in VE /etc/sysctl.conf file or in /proc.
"
and there may be a path to a solution.

>
> Cheers,
>
> WBL
>
> --
> "Quality comes from focus and clarity of purpose" -- Mark Shuttleworth


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general