← Back to team overview

openbravo-isv team mailing list archive

Re: PostgreSQL shared memory

 

Hi Gorka,

Just wanted to give you a quick update.  As of today, this issue was
escalated in our kernel team and they will look into whether or not this has
unintended consequences or not and decide on whether to change the setting
in our kernel builds.  I'll ping you again when I have more news.

-Brian

P.S. The first Beta of Maverick just dropped which is when we start
migrating packages.  Are you interested in having Openbravo in the maverick
partner repo or just stick with LTS releases?

On Thu, Aug 26, 2010 at 1:38 PM, Brian Thomason <
brian.thomason@xxxxxxxxxxxxx> wrote:

> Hi Gorka,
>
> Sorry, I dropped the ball here. It appears you are not even close to being
> alone on this one:
>
> https://bugs.edge.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/264336
>
> They frown upon the idea of your method as it would open the door to many
> packages doing it.  The consensus seemed to be to update the value in the
> kernel itself but it appears no headway has been made there.  I just sent of
> an email to one of our kernel engineers and will get back with you when he
> replies.
>
> -Brian
>
>
> On Thu, Aug 26, 2010 at 6:18 AM, Gorka Gil <gorka.gil@xxxxxxxxxxxxx>wrote:
>
>> Brian,
>>
>> > I'd have to talk to an archive admin to see if they'd allow this [...]
>>
>> Any update in this story?
>>
>> Are the archive admin agree with the solution of place a file in
>> /etc/sysctl.d/ and just inform to the user?
>>
>> Regards,
>> Gorka
>>
>> On Wed, Jul 28, 2010 at 17:37, Brian Thomason
>> <brian.thomason@xxxxxxxxxxxxx> wrote:
>> > I'd have to talk to an archive admin to see if they'd allow this in, but
>> the
>> > proper way to do it would be to message the user (not necessarily ask,
>> just
>> > inform) and place a file in /etc/sysctl.d/
>> > -Brian
>> >
>> > On Wed, Jul 28, 2010 at 7:37 AM, Gorka Gil <gorka.gil@xxxxxxxxxxxxx>
>> wrote:
>> >>
>> >> Hi Brian,
>> >>
>> >> In order for some process of Openbravo ERP works correctly we need to
>> >> increase the shared memory of PostgreSQL.
>> >>
>> >> By default the shared memory of the system is 32MB that is enough for
>> >> one instance of PostgreSQL, but the problem is that there is two
>> >> instances of PostgreSQL running at the same time: the System one and
>> >> the Openbravo ones.
>> >>
>> >> The process to fix it should be similar to this:
>> >>
>> >> # check the current shmmax assigned MB
>> >> echo $(cat /proc/sys/kernel/shmmax) / 1024 / 1024 | bc
>> >>
>> >> If the result is less than 128 (recomended in PostgreSQL manuals [1])
>> >>
>> >> # Increase it to 128 MB
>> >> sudo sh -c 'echo "kernel.shmmax = 134217728" >> /etc/sysctl.conf'
>> >> sudo sysctl -p
>> >>
>> >> Brian,
>> >> How is the best way to manage this?
>> >> A message to the user? automate it in the package postinst script? ...
>> >>
>> >> Thanks,
>> >> Gorka
>> >>
>> >> [1] http://www.postgresql.org/docs/8.4/static/kernel-resources.html
>> >>
>> >> _______________________________________________
>> >> Mailing list: https://launchpad.net/~openbravo-isv
>> >> Post to     : openbravo-isv@xxxxxxxxxxxxxxxxxxx
>> >> Unsubscribe : https://launchpad.net/~openbravo-isv
>> >> More help   : https://help.launchpad.net/ListHelp
>> >
>> >
>>
>
>

Follow ups

References