> On Dec 9, 2017, at 8:42 AM, Blake McBride <blake@xxxxxxxxxxxx> wrote: > > Greetings, > > 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 an easy way for me to fix this (like export with some compatibility flag)? > > Thanks! > > Blake McBride > 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?
