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

On 06/18/2014 04:05 AM, Khangelani Gama wrote:
> -----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:

The other strange thing is:

ERROR: missing data for column "fpp_cde"
CONTEXT: COPY audit, line 2565159: "4585427 21~21~21 5143 0 2013-12-01
15:03:18.336718 <?xml version="1.0" encoding="UTF-8"?>\r\n<nonF..."
STATEMENT: COPY audit (aud_id, grp_cde, act_typ, aud_ver, usr_id,
aud_device_id, aud_ts, aud_xml,

aud_id      4585427
grp_code 21~21~21
act_type 5143
aud_ver  0
usr_id 2013-12-01 15:03:18.336718 ???? Is this not aud_ts?
aud_device_id  <?xml version="1.0" encoding="UTF-8"?>\r\n<nonF... ?????
Is this not aud_xml?

Which begs the question where did usr_id and aud_device_id go?

--
Adrian Klaver
adrian.klaver@aklaver.com