-----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. 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.
