Rob Sargent <robjsargent@xxxxxxxxx> writes: >> On Dec 9, 2017, at 8:42 AM, Blake McBride <blake@xxxxxxxxxxxx> 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
