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

From Adrian Klaver
Subject Re: pg_restore: custom archiver unexpected end of file , ERROR: missing data for column
Date
Msg-id 53A0FA1C.6030400@aklaver.com
Whole thread Raw
In response to Re: pg_restore: custom archiver unexpected end of file , ERROR: missing data for column  (Khangelani Gama <kgama@argility.com>)
Responses Re: pg_restore: custom archiver unexpected end of file , ERROR: missing data for column
List pgsql-general
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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re:
Next
From: itishree sukla
Date:
Subject: Application crashing due to idle connection