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 <[email protected]> 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
> <[email protected]> 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 <[email protected]>
> 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     : [email protected]
> >> Unsubscribe : https://launchpad.net/~openbravo-isv
> >> More help   : https://help.launchpad.net/ListHelp
> >
> >
>
_______________________________________________
Mailing list: https://launchpad.net/~openbravo-isv
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~openbravo-isv
More help   : https://help.launchpad.net/ListHelp

Reply via email to