clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
It looks like something went wrong when you upgraded. You have to check that the port and listen_addresses are correct. Perhaps the listen_address changed and the instance isn't listening on the host anymore?

The reason that pg_dump and the other tools are still working is probably because they're connecting over the unix socket instead over TCP/IP. clusterdb should also be able to do that if you just leave out the -h and -p options.

The pg_hba.conf is not relevant because your client can't connect to the server at all. You can verify that the server is listening on the expected host and port with telnet &lt;host&gt; &lt;port&gt;.

http://www.postgresql.org/docs/9.2/static/runtime-config-connection.html