dhis2-users team mailing list archive

[channara rin <rin.channara@xxxxxxxxx>]

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 <bobjolliffe@xxxxxxxxx>
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 <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
> >>
>