← Back to team overview

openbravo-isv team mailing list archive

Re: PostgreSQL shared memory

 

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