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