← Back to team overview

dhis2-users team mailing list archive

Re: Restore a large PostgreSQL dump

 

Knut and Jason are both right.  There is no point dumping tables which can
be recreated.

But that in itself shouldn't cause an error restoring a dump and 16G is far
from huge (of course too big for notepad++ but that's a different issue).
What was the error message?

On 11 March 2015 at 16:39, Knut Staring <knutst@xxxxxxxxx> wrote:

> This advice may be a bit late for you,  but I would recommend excluding
> analytics when you do a backup.
> On 11 Mar 2015 17:31, "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
>>
>>
> _______________________________________________
> 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
>
>

Follow ups

References