Dear Channara, Have you configure environmental variables for DHIS2 on the desktop?
Regards, Gerald On Mar 19, 2016 02:14, "channara rin" <rin.chann...@gmail.com> wrote: > Hi bob, > when i backup, i use command pg_dumpall. > i can restore on my personal laptop with 4GB Memory. but for desktop seem > out of memory. > i will re-check again on task manager what is still processing. > > On Fri, Mar 18, 2016 at 11:14 PM, Bob Jolliffe <bobjolli...@gmail.com> > wrote: > >> 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 <bobjolli...@gmail.com> 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.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-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
