← Back to team overview

dhis2-users team mailing list archive

Re: Restore a large PostgreSQL dump

 

Easiest way is to not dump the analytics tables at all.  They  can be
regenerated by running the analytics process once you have restores your
database without these tables.

Regards,
Jason
On Mar 11, 2015 5:31 PM, "Ngoni Manika" <nmanika@xxxxxxxxxxx> wrote:

> Hi team
>
>
>
> I am having a challenge on restoring a postres dump which is large
> (16gig), it gives an error on restoring data in table analytics 2014.
>
>
>
> Can anyone please help with how I can go around it, or maybe how to edit
> the dump (notepad++ cannot open the file is too large).
>
>
>
> Regards
>
>
>
> *Ngonidzashe Manika*
>
> *Data Officer*
>
> *+*263 772 789673, nmanika@xxxxxxxxxxx, skype: ngoni.manika
>
> Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library,
> Mkwati Building
>
>
>
> _______________________________________________
> 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
>
>

References