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-users@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-users@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-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp