[Dhis2-users] restore database out of memory

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

Re: [Dhis2-users] restore database out of memory

Hi Channara, What values do you have for JAVA_OPTS? On Fri, Mar 18, 2016 at 1:10 PM, channara rin 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

Re: [Dhis2-users] restore database out of memory

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 wrote: > Ah

Re: [Dhis2-users] restore database out of memory

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

Re: [Dhis2-users] restore database out of memory

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

Re: [Dhis2-users] restore database out of memory

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

Re: [Dhis2-users] restore database out of memory

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

Re: [Dhis2-users] restore database out of memory

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 wrote: > One other

Re: [Dhis2-users] restore database out of memory

Dear Channara, Have you configure environmental variables for DHIS2 on the desktop? Regards, Gerald On Mar 19, 2016 02:14, "channara rin" wrote: > Hi bob, > when i backup, i use command pg_dumpall. > i can restore on my personal laptop with 4GB Memory. but for desktop