Dumping and restoring tables in PostgreSQL - ERROR: extra data after last expected column
Turned out to be a minor corruption of the SQL backup file.
After re-running the entire process again, the restore worked fine with no errors. 

You would think that Postgres would have in-built checking to ensure integrity of exported data!