Re: pg_restore: custom archiver unexpected end of file , ERROR: missing data for column

-----Original Message-----
From: Khangelani Gama [mailto:kgama(at)argility(dot)com]
Sent: Wednesday, June 18, 2014 1:06 PM
To: 'Adrian Klaver'; 'Andres Freund'; 'Tom Lane'
Cc: 'Alban Hertroys'; 'Ziggy Skalski'; 'pgsql-general(at)postgresql(dot)org'
Subject: RE: [GENERAL] pg_restore: custom archiver unexpected end of file ,
ERROR: missing data for column

-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: Wednesday, June 18, 2014 4:32 AM
To: Khangelani Gama; Andres Freund; Tom Lane
Cc: Alban Hertroys; Ziggy Skalski; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] pg_restore: custom archiver unexpected end of file ,
ERROR: missing data for column

On 06/17/2014 10:37 AM, Khangelani Gama wrote:
> -----Original Message-----
> From: Andres Freund [mailto:andres(at)2ndquadrant(dot)com]
> Sent: Tuesday, June 17, 2014 4:38 PM
> To: Tom Lane
> Cc: Alban Hertroys; Khangelani Gama; Ziggy Skalski;
> pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] pg_restore: custom archiver unexpected end of
> file , ERROR: missing data for column
>
> On 2014-06-17 10:25:45 -0400, Tom Lane wrote:
>> Alban Hertroys <haramrae(at)gmail(dot)com> writes:
>>> Or just connect your 9.2.4 pg_dump remotely to your 8.4 server.
>>
>> FWIW, the described behavior sounded like the dump file had gotten
>> truncated somewhere along the line. Maybe it's just necessary to
>> re-do the transfer of the existing dump file.
>
> Hi Tom, I tried the dump several times, and dumped it more than once
> but no luck.
>

My suspicion is the XML field two places before the fpp_cde field.
Interested in seeing if the 9.4 dump will handle it better.

Adrian you might be right I have just tried to pg_restore on the same
server(8.4.2), I get the same errors related to xml. Can someone advise if
the following XML file as an example is in the correct state or not:

<?xml version="1.0" encoding="UTF-8"?>\r

+
<nonFinancialEventVer01
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="accountEjb.xsd"><actH01><uiD01><userId
/><deviceId /></uiD01><transData01><actionType>5
143</actionType><isFinancial>false</isFinancial><docDate>1385903062657</docDate><docNo>4585427</docNo><buildNumber>2013-11-08
:11:14:16</buildNumber><isCredit>false</isCredit><isCashType>false</isC
ashType></transData01><seqD01><audit>4585427</audit><finProcPer>201311</
ashType>finProcPer><branchCode>0023</branchCode><grpCode>21~21~21</grpCo
ashType>de><hpDoc>1807125</hpDoc></seqD01></actH01><accountData01><br
anch>0023</branch><account>103558</account><contract>1</contract><valueD
anch>ata01><value>0.00</value></valueData01><statusData01><finProc>20131
anch>1</finProc><status>INACTIVE</status><balance>0.00</balance
><arrears>0.00</arrears><due>0.00</due><fupStat
>/><inst>101.21</inst><mthNotPay>0</mthNotPay><provArrMth>0</provArrMth>
><provInstPay>0</provInstPay><provAmt>0.00</provAmt><provPcnt>0.0</provP
>cnt><de
bMtd>0.00</debMtd><crdMtd>0.00</crdMtd><payMtd>0.00</payMtd><intMtd>0.00
bMtd></intMtd><rebFin>0.00</rebFin><rebIns>0.00</rebIns><finProv>0.00</f
bMtd>inProv><insProv>0.00</insProv><provNPTyp /><depMtd>0.00</d
epMtd><openArrears>0.00</openArrears><rebClub>0.00</rebClub><nxtMthOpnRe
epMtd>cency>0</nxtMthOpnRecency><finRebMtd>0.00</finRebMtd><insRebMtd>0.
epMtd>00</insRebMtd><empericaScore>0</empericaScore><avgDelq>0</a
vgDelq><worstAge>8224</worstAge><monthsDelq>0</monthsDelq><openNowDue>0.
vgDelq>0</openNowDue><queuePriority
vgDelq>/><triadQueue>bdc03</triadQueue><hpfstatNcaIntMtd>0.00</hpfstatNc
vgDelq>aIntMtd><hpfstatNcaIntLtd>0.00<
/hpfstatNcaIntLtd><hpfstatAddIntMtd>0.00</hpfstatAddIntMtd><hpfstatAddIntLtd>0.00</hpfstatAddIntLtd><hpfstatCrLifeInsMtd>0.00</hpfstatCrLifeInsMtd><hpfstatCrLifeInsLtd>0.00</hpfstatCrLifeInsLtd><hp
fstatAddCrLifeInsMtd>0.00</hpfstatAddCrLifeInsMtd><hpfstatAddCrLifeInsLt
fstatAddCrLifeInsMtd>d>0.00</hpfstatAddCrLifeInsLtd><hpfstatClubMtd>0.00
fstatAddCrLifeInsMtd></hpfstatClubMtd><hpfstatClubLtd>0.00</hpfstatClubL
fstatAddCrLifeInsMtd>td><hpfstatServiceFeeMt
d>0.00</hpfstatServiceFeeMtd><hpfstatServiceFeeLtd>0.00</hpfstatServiceF
d>eeLtd><hpfstatOptInsMtd>0.00</hpfstatOptInsMtd><hpfstatOptInsLtd>0.00<
d>/hpfstatOptInsLtd><hpfstatWoff>0.00</hpfstatWoff><hpfst
atdebltd>1437.06</hpfstatdebltd><hpfstatcrdltd>-25.01</hpfstatcrdltd><hp
atdebltd>fstatpayltd>-1412.05</hpfstatpayltd><hpfstatintltd>0.00</hpfsta
atdebltd>tintltd><hpfstatdepltd>400.00</hpfstatdepltd><contDelq>0</cont
Delq><hpfstatLastPayDte>948405600000</hpfstatLastPayDte><hpfstatIndupBal
Delq>>0.00</hpfstatIndupBal><hpfstatIndupLtd>0.00</hpfstatIndupLtd></sta
Delq>tusData01></accountData01><docValueData01><branch>0023</br
anch><account>103558</account><value>0.00</value></docValueData01></nonF
anch>inancialEventVer01>\r+

Is \r + and \r+ valid on this XML file? , I need to tell application
Developers if this right or not.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential
information of Argility (Proprietary) Limited and/or its subsidiaries. Any review, use or dissemination thereof by anyone
other than the intended addressee is prohibited.If you are not the intended addressee please notify the writer immediately
and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability
for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.