← Back to team overview

dhis2-users team mailing list archive

Re: restore database out of memory

 

One other quick thought that is easy to test and eliminate.  Postgres
out of memory errors on restore can also result from a corrupted dump
file.  It might be worthwhile to check on another system that your
dump is good.

On 18 March 2016 at 17:08, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
> 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