I've tried doing a pg_dumpall from a postgresql 9.0 database, restoring that to a postgresql 9.5 database, but I get many errors related to parsing the geometries. I came across this thread where the poster had a similar issue to mine, and the workaround of using ArcCatalog to copy data from the old to new database seems to work without any issues.
I ran into the same issue following the instructions in the links that you've posted.