Message-ID: <533541D4.6080500@b-one.net>
Date: Fri, 28 Mar 2014 15:03:08 +0530
From: Reynold PJ <reynoldp@b-one.net>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20131103 Icedove/17.0.10
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] openvz and shared memory trouble
References: 
 <CAHnozTjxUrfbaZVFbzibLQmhzR-n9ty+ktyRN2a0Tyr9PhApqQ@mail.gmail.com>
In-Reply-To: 
 <CAHnozTjxUrfbaZVFbzibLQmhzR-n9ty+ktyRN2a0Tyr9PhApqQ@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="----enig2SELLEXQCBSEJIAEDHQBT"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
------enig2SELLEXQCBSEJIAEDHQBT
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On 03/28/2014 02:21 PM, Willy-Bas Loos wrote:
> Hi,
>=20
> I have a problem with postgres in combination with openvz.
> My hot standby crashes on me when i give it a normal value for
> shared_buffers (4GB, which 25% of the memory in the container).
> When i tune down the shared_buffers, it works again. But of course this=
 is
> far from desireable.
>=20
> Now, i've seen a couple more messages around the net about openVZ and
> postgres that weren't very encouraging:
>=20
> http://www.postgresql.org/message-id/CAHyXU0xa5EgvjeH=3D4vp-eZDJdS5kMQu=
iDivvTRLjY-uZ62Y44w@mail.gmail.com
> http://www.postgresql.org/message-id/23206.1254683408@sss.pgh.pa.us
> http://postgresql.1045698.n5.nabble.com/BUG-9721-Fatal-error-on-startup=
-no-free-slots-in-PMChildFlags-array-td5797390.html
>=20
> But i am in a position where we already have a pretty strong binding wi=
th
> openVZ.
> I also have a colleague that has been using openVZ and postgres on
> production for quite a while now, without any problems. And already 1 o=
f
> our servers is running a production database in openVZ that is well use=
d,
> without any trouble of this kind.
>=20
> Now, what i would like to know is:
>=20
>    - is there clarity about what the issues are at all
>    - is it just 1 problem (in openVZ) that make openVZ and postgres so
>    poorly compatible?
>    - how can i stay out of trouble (when using postgres inside openVZ)

Try increasing the share memory "shmpages" of container from host.


>    - who else has trouble with openVZ in combination with postgres, and=

>    what constitutes the trouble?
>=20
> regards,
>=20
> WBL
>=20
>=20


------enig2SELLEXQCBSEJIAEDHQBT
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iQEcBAEBAgAGBQJTNUHUAAoJENi6jUVHG4qDgy0H/j5tUDwSGaI/wJVCE0pgvuLB
TXaz4ZCVzq8UIzjznSyN/6wQdZHief2aO8SSvlaNl3ufnDLBc2/auRHarYZ2vzKb
ZPUB84gHQk7202PHhu7c2o9DSMh/bVRPlK6DXIljSFW6A/pdbBYPViifCjCYd2NJ
LiN0L8+mgfGgBq0+5x0IMJX1SVuTwSuVOTVPy5rS51dY3ENYZZbFyLpySrnKSior
EwNRPAo851K+tnWnUtL3Nk4ml8t3+j9M/NAMfKDc38bblJnn3j2OVAQawNgTxqrI
/CRUD8ehsRAe2xdjWCBallrHYkOfNEJ3d/M2fGDbOj938lQw4mzh5oArFaDC88U=
=7Gvx
-----END PGP SIGNATURE-----

------enig2SELLEXQCBSEJIAEDHQBT--