If you happen to be upgrading postgresql through a dump/reload cycle and get lots of errors like
“psql:db.dump:26268: invalid command \N”
It’s really simple. You probably haven’t loaded a schema yet, either by doing a data-only dump when you meant to do a full dump or by just forgetting to load the schema.
Also, at least in version 8.2, there’s a point in the schema dump where all the tables are in, but none of the constraints or indexes. That’s a real good place to split the file and do the data load.No comments