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-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
