← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] restore database out of memory

 

Ah you are on Windoze.  I also don't have much real experience of
running dhis2 other than on linux, but it strikes me that
(i) 4G machine is small but should still "work"
(ii) the databse size you are talking about 100m is quite small and
the restore operation should not be consuming vast amounts of memory
(iii) postgres will run, albeit not very efficiently, with quite small
amounts of memory.

So ...

I think you need to look at what else you have running on that machine
which could be consuming the bulk of memory.  I think windoze system
tools like task manager and perfmon.exe might show you useful
information.

Have you modified postgres config or is it default setting?  Default
settings would be very conservative but should work.  If you have
modified, you might have given postgres the impression it has more
memory available than actually exists.

On 18 March 2016 at 16:53, channara rin <rin.channara@xxxxxxxxx> wrote:
> No from hard drive. it has free disk space 100GB for C: and D: is 45GB
>
> On Fri, Mar 18, 2016 at 10:31 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>
>> Sorry Channara, I didn't read your question properly, this has nothing to
>> do with JAVA_OPTS.
>>
>> Unfortunately, I have no experience with getting Postgres out of memory
>> errors, though google tells me a lot of people do.
>>
>> Could it perhaps be that your hard drive is filling up?
>>
>> On Fri, Mar 18, 2016 at 3:38 PM, channara rin <rin.channara@xxxxxxxxx>
>> wrote:
>>>
>>> here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8 -server
>>> -Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m -XX:PermSize=256m
>>> -XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
>>> -XX:+DisableExplicitGC
>>>
>>> On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>>>
>>>> Hi Channara,
>>>>
>>>> What values do you have for JAVA_OPTS?
>>>>
>>>> On Fri, Mar 18, 2016 at 1:10 PM, channara rin <rin.channara@xxxxxxxxx>
>>>> wrote:
>>>>>
>>>>> hi all,
>>>>> do you hav any experience with postgresql database?
>>>>> i use command psql/pg_restore into new system. i got out of memory.
>>>>> my system server is 4GB memory and file backup size is around 100MB
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Knut Staring
>>>> Dept. of Informatics, University of Oslo
>>>> Norway: +4791880522
>>>> Skype: knutstar
>>>> http://dhis2.org
>>>
>>>
>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


Follow ups

References