← Back to team overview

openbravo-isv team mailing list archive

Re: PostgreSQL shared memory

 

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