3 ms·
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
by TylerE 13y ago
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.
- astrodust 13y agoThis thing? http://www.pgadmin.org/ http://www.pgadmin.org/ This is why I hate using Postgres despite it being such an amazing database internally. PGAdmin is everything that's wrong with database tools rolled into an executable.
- reactor 13y agoIf you dont mind using eclipse, you can use 'toad' eclipse plugin, which is really good.
- untog 13y agoPGAdmin 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.
- TylerE 13y agoWhat 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.
- jordanthoms 13y agoPGAdmin 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.
- judk 13y agoSad to hear that hasn't been fixed since I left a couple of years ago...
- aquadrop 13y agoI 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.
- sanderjd 13y agoWell, 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. [0]: https://code.google.com/p/sequel-pro/source/browse/#svn%2Ftrunk%2FFrameworks%2FPostgresKit https://code.google.com/p/sequel-pro/source/browse/#svn%2Ftr...
- nobleach 13y agoI'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.
- f3r3nc 13y agoWorkaround, why not making the tunnel yourself? ssh -L5555:127.0.0.1:5432 host Then you have it on your local 5555.