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

No comments yet. Be the first.

Leave a reply

You must be logged in to post a comment.