dhis2-users team mailing list archive

[Ngoni Manika <nmanika@xxxxxxxxxxx>]

Thanks Bob

 

Below is the error im getting

 

pg_restore: [archiver (db)] Error while PROCESSING TOC:

pg_restore: [archiver (db)] Error from TOC entry 5328; 0 1415587 TABLE DATA
analytics_2014 postgres

pg_restore: [archiver (db)] COPY failed for table "analytics_2014": ERROR:
missing data for column "NDAElbuYMNM"

CONTEXT:  COPY analytics_2014, line 11201741: "\N         \N           \N
\N           \N           xuuDrpnpEPD    c2g5zOOo"

pg_restore: restoring data for table "analytics_2015"

pg_restore: [tar archiver] corrupt tar header found in \N (expected 3679,
computed 33533) file position 9118576128

 

Regards

 

Ngonidzashe Manika

Data Officer

+263 772 789673, nmanika@xxxxxxxxxxx <mailto:nmanika@xxxxxxxxxxx> , skype:
ngoni.manika

Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library,
Mkwati Building

 

From: Bob Jolliffe [mailto:bobjolliffe@xxxxxxxxx] 
Sent: Wednesday, March 11, 2015 6:52 PM
To: Knut Staring
Cc: Ngoni Manika; dhis2-users
Subject: Re: [Dhis2-users] 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
<mailto: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
<mailto: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 <mailto: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
<mailto: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
<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx> 
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp