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

-----Original Message-----
From: Andres Freund [mailto:andres(at)2ndquadrant(dot)com]
Sent: Tuesday, June 17, 2014 4:38 PM
To: Tom Lane
Cc: Alban Hertroys; Khangelani Gama; Ziggy Skalski;
pgsql-general(at)postgresql(dot)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(at)gmail(dot)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.

Any chance there was windows in the mix somewhere? IIRC there were bugs
with large dumps there for a while...
Hi, Andres servers are running on Linux

Thanks Alban Hertroys, I managed to install postgres 9.2.4 binaries onto
the postgres 8 server, on a different path, and have dumped the database
using postgres 9 bin with no errors.....Now busy copying the files over
the network because these servers are far from each other. I will advise
on the pg_restore results, hopefully it will work.

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

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.