So far so good, a couple of minor things. 

It seems I had PostgreSQL 9.5 on my system. Then installing with your instructions worked fine. And all the continuing step also.

Only thing that did not really work was your import command. Due to the password missing. Setting <a href="https://gist.github.com/AtulKsol/4470d377b448e56468baef85af7fd614">md5</a> as method requires the password input.
Therefore I used  a query like this to import, as you can read in the cited source:

```
psql --host=localhost --dbname=hive --username=hive -f hive_latest.sql
```