Re: 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 Klaver
adrian.klaver@aklaver.com