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.chann...@gmail.com> 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 <knu...@gmail.com> 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.chann...@gmail.com> >> 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 <knu...@gmail.com> wrote: >>>> >>>> Hi Channara, >>>> >>>> What values do you have for JAVA_OPTS? >>>> >>>> On Fri, Mar 18, 2016 at 1:10 PM, channara rin <rin.chann...@gmail.com> >>>> 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-us...@lists.launchpad.net >>>>> 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-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
