Huh? There's the great free PGAdmin which is WAY better than any of the web-based tools, and it has built-in SSH tunneling so it's easy to use against a remote server.
PGAdmin is unspeakably awful. I run a Mac and it was very painful going from the world of Sequel Pro (for MySQL) to the awful, awful, terrible pgAdmin.
I ended up buying NaviCat Essentials, which is considerably better but still not perfect.
What do you find to be wrong with it? It's always done the job well for me, whereas Sequel Pro, while a prettier face, and useable enough, manages to crash at least once a day.
PGAdmin crashes regularly, and in a very annoying (and stupid!) move blocks the UI for all the windows on some database operations e.g. adding indexes. It also blocks the UI when it's processing the results of a db query, which can be slow if there is a lot of data being returned. The interface is sort-of ok though.
I don't see how that's "unspeakable bad, terrible, terrible". Latest versions crash a lot less and if you really need to use UI during long database queries you can run another instance of pgadmin. It's still very useful and powerful tool.
Well, SequelPro at least started adding support for Postgres[0], but it's hard to tell how far along it is. Most of the commits in that tree seem to be from last September, with a smattering from January and May of this year.
I'd say it _almost_ has SSH tunneling built in. They're 95.418% there. It's still hardcoded to only use port 22. You can't specify another port. In my case, I have to hop through other machines and if I have SSHd running on my local box, I can't use their SSH tunneling.
