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
