Re: pg_restore: custom archiver unexpected end of file , ERROR: missing data for column - Mailing list pgsql-general

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Wednesday, June 18, 2014 4:32 AM
To: Khangelani Gama; Andres Freund; Tom Lane
Cc: Alban Hertroys; Ziggy Skalski; pgsql-general@postgresql.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@2ndquadrant.com]
> Sent: Tuesday, June 17, 2014 4:38 PM
> To: Tom Lane
> Cc: Alban Hertroys; Khangelani Gama; Ziggy Skalski;
> pgsql-general@postgresql.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@gmail.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</finProcPer><branchCode>0023</branchCode><grpCode>21~21~21</grpCode><hpDoc>1807125</hpDoc></seqD01></actH01><accountData01><br

anch>0023</branch><account>103558</account><contract>1</contract><valueData01><value>0.00</value></valueData01><statusData01><finProc>201311</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</provPcnt><de

bMtd>0.00</debMtd><crdMtd>0.00</crdMtd><payMtd>0.00</payMtd><intMtd>0.00</intMtd><rebFin>0.00</rebFin><rebIns>0.00</rebIns><finProv>0.00</finProv><insProv>0.00</insProv><provNPTyp
/><depMtd>0.00</d

epMtd><openArrears>0.00</openArrears><rebClub>0.00</rebClub><nxtMthOpnRecency>0</nxtMthOpnRecency><finRebMtd>0.00</finRebMtd><insRebMtd>0.00</insRebMtd><empericaScore>0</empericaScore><avgDelq>0</a
vgDelq><worstAge>8224</worstAge><monthsDelq>0</monthsDelq><openNowDue>0.0</openNowDue><queuePriority
/><triadQueue>bdc03</triadQueue><hpfstatNcaIntMtd>0.00</hpfstatNcaIntMtd><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><hpfstatAddCrLifeInsLtd>0.00</hpfstatAddCrLifeInsLtd><hpfstatClubMtd>0.00</hpfstatClubMtd><hpfstatClubLtd>0.00</hpfstatClubLtd><hpfstatServiceFeeMt

d>0.00</hpfstatServiceFeeMtd><hpfstatServiceFeeLtd>0.00</hpfstatServiceFeeLtd><hpfstatOptInsMtd>0.00</hpfstatOptInsMtd><hpfstatOptInsLtd>0.00</hpfstatOptInsLtd><hpfstatWoff>0.00</hpfstatWoff><hpfst

atdebltd>1437.06</hpfstatdebltd><hpfstatcrdltd>-25.01</hpfstatcrdltd><hpfstatpayltd>-1412.05</hpfstatpayltd><hpfstatintltd>0.00</hpfstatintltd><hpfstatdepltd>400.00</hpfstatdepltd><contDelq>0</cont

Delq><hpfstatLastPayDte>948405600000</hpfstatLastPayDte><hpfstatIndupBal>0.00</hpfstatIndupBal><hpfstatIndupLtd>0.00</hpfstatIndupLtd></statusData01></accountData01><docValueData01><branch>0023</br
anch><account>103558</account><value>0.00</value></docValueData01></nonFinancialEventVer01>\r+
















--
Adrian Klaver
adrian.klaver@aklaver.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.