[ADMIN]openvz and shared memory trouble

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: [ADMIN]openvz and shared memory trouble
Date: 2014-03-28 08:51:46
Message-ID: CAHnozTjxUrfbaZVFbzibLQmhzR-n9ty+ktyRN2a0Tyr9PhApqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi,

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.

Now, i've seen a couple more messages around the net about openVZ and
postgres that weren't very encouraging:

http://www.postgresql.org/message-id/CAHyXU0xa5EgvjeH=4vp-eZDJdS5kMQuiDivvTRLjY-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

But i am in a position where we already have a pretty strong binding with
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 of
our servers is running a production database in openVZ that is well used,
without any trouble of this kind.

Now, what i would like to know is:

- 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)
- who else has trouble with openVZ in combination with postgres, and
what constitutes the trouble?

regards,

WBL

--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Reynold PJ 2014-03-28 09:33:08 Re: [GENERAL] openvz and shared memory trouble
Previous Message Jason Mathis 2014-03-25 22:13:49 Re: archiving wal files after PITR

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2014-03-28 08:54:28 Re: Oracle_FDW - Cache lookup failed
Previous Message Khangelani Gama 2014-03-28 05:51:44 Re: Synchronizing a table that is two different databases : Need to dump a table a insert from db1 and change the insert statements into UPDATE statements