← Back to team overview

openbravo-isv team mailing list archive

Re: PostgreSQL shared memory

 

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