-----Original Message----- From: Khangelani Gama [mailto:kgama@xxxxxxxxxxxx] Sent: Wednesday, June 18, 2014 1:06 PM To: 'Adrian Klaver'; 'Andres Freund'; 'Tom Lane' Cc: 'Alban Hertroys'; 'Ziggy Skalski'; 'pgsql-general@xxxxxxxxxxxxxx' Subject: RE: [GENERAL] pg_restore: custom archiver unexpected end of file , ERROR: missing data for column -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] Sent: Wednesday, June 18, 2014 4:32 AM To: Khangelani Gama; Andres Freund; Tom Lane Cc: Alban Hertroys; Ziggy Skalski; pgsql-general@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxxxx] > Sent: Tuesday, June 17, 2014 4:38 PM > To: Tom Lane > Cc: Alban Hertroys; Khangelani Gama; Ziggy Skalski; > pgsql-general@xxxxxxxxxxxxxx > 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@xxxxxxxxx> 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.klaver@xxxxxxxxxxx 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.
