dhis2-devs team mailing list archive

[Orvalho Augusto <orvaquim@xxxxxxxxx>]

Thanks!!

That of restoring a database of huge size is not everyday you do.

I need people with databases of Postgres with sizes above 5GB. And tell us
how their postgres behave, specifically tell us how they address the vaccum
data thing.

Please is not a war.

Caveman





2010/7/12 Lars Helge Øverland <larshelge@xxxxxxxxx>

> Hi Caveman, we are definitely not dropping mysql support, its just
> that most of the devs are using postgres so a function not being
> mysql-compliant might sneak in from time to time. I tested most of the
> application on mysql recently without trouble.
>
> A common problem with aggregation earlier was the way the orgunit
> hierarchy was represented and stored, this is changed in 2.0.5
> snapshot and is way less error-prone now. So please build yourself a
> war-file from trunk and test with that.
>
> If that doesn't work please send me a database dump and I will have a
> look. (On a sidenote a main reason for choosing postgres is the way
> dumps are restored - mysql uses single regular sql insert statements
> which might take days for very large databases while postgres uses
> more "native" copy statements which never takes more than minutes).
>
> cheers, Lars
>
>
>
> 2010/7/12 Orvalho Augusto <orvaquim@xxxxxxxxx>:
> > I need to have a repo/table that aggregates data as I asked before. I did
> > not find it on docs.
> >
> > Someone told me that can happens if a generate those resource tables. I
> try
> > to generate those tables and I get stuck on that error I reported.
> >
> > Good for me if I do not need to generate such tables and ask what I
> should
> > do?
> >
> > Caveman
> >
> >
> > 2010/7/12 Lars Helge Øverland <larshelge@xxxxxxxxx>
> >>
> >> Generating any of the resource tables don't affect the aggregation /
> >> report tables...
> >>
> >>
> >>
> >> On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto <orvaquim@xxxxxxxxx>
> >> wrote:
> >> > Thanks!!!
> >> >
> >> > Caveman
> >> >
> >> >
> >> > On Sun, Jul 11, 2010 at 5:03 PM, Jason Pickering
> >> > <jason.p.pickering@xxxxxxxxx> wrote:
> >> >>
> >> >> A very common mistake is not having generated the resource tables,
> >> >> namely "orgunitstructure". Consult the documentation for more details
> >> >> on how to generate these tables.
> >> >>
> >> >> Regards,
> >> >> Jason
> >> >>
> >> >>
> >> >> On Sun, Jul 11, 2010 at 4:27 PM, Orvalho Augusto <orvaquim@xxxxxxxxx
> >
> >> >> wrote:
> >> >> > I have a dataelement collected at a Health Centre level (eg:
> >> >> > ats_posfem)
> >> >> > in
> >> >> > one province and only in some particular districts. In
> unpredictible
> >> >> > future
> >> >> > at National level we will be collecting on every health centre.
> >> >> >
> >> >> > Now, my ignorance: How can I obtain the provincial total on Report
> >> >> > Table? I
> >> >> > have been battled with DHIS so far and nothing.
> >> >> >
> >> >> > Thanks guys
> >> >> > Caveman
> >> >> >
> >> >> >
> >> >> > _______________________________________________
> >> >> > Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> >> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> >> > Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> >> > More help   : https://help.launchpad.net/ListHelp
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >> --
> >> >> Jason P. Pickering
> >> >> email: jason.p.pickering@xxxxxxxxx
> >> >> tel:+260968395190
> >> >
> >> >
> >> >
> >> >
> >> > _______________________________________________
> >> > Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> > Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> > More help   : https://help.launchpad.net/ListHelp
> >> >
> >> >
> >
> >
> >
> >
>