Rob Sargent <robjsarg...@gmail.com> writes:
>> On Dec 9, 2017, at 8:42 AM, Blake McBride <bl...@mcbride.name> wrote:
>> I am using pg_dump on version 9.5.10 and trying to import it on version 
>> 9.3.20.  Many (or all) COPY commands are failing with messages like:  
>> psql:16504.db:16874: ERROR:  missing data for column "street"
>> CONTEXT:  COPY address, line 1: ""

> Is there in fact ‘street’ data in the file?   Sounds like you have the wrong 
> number of columns. Do you have your actual dump and restore commands to show 
> here?

While pg_dump certainly does sometimes produce output that doesn't reload
into older servers, we try to minimize such problems --- and in any case,
the actual COPY data shouldn't be a source of issues.  I'm suspicious that
the true problem occurred earlier; maybe a table drop/creation failed
and now COPY is trying to load into a pre-existing table that has the
right name and the wrong column list.

I'd counsel looking at the *first* error message and resolving that,
then trying again.  Anything later could just be cascaded failures.

                        regards, tom lane

Reply via email to