Shall the new role be allowed to create databases? (y/n) n Shall the new role be a superuser? (y/n) n When I get to the step where you createuser i get. Postgres on Ubuntu 11.04 for Ruby and Rails developmentįollowed your instructions to the letter, but am getting a permissions issue when I try to run any of the postgres commands (createuser, createdb, pgsql, etc.) Fast, Good UI, Import & Export capabilities and good sql editor inside.īoth are good for PG but dbvis is the best choice if you need multiple db engines. If you use many db engines, dbvis is one of the app that you have to consider. All of the most things you need is there.Īlso consider DbVisualizer (java based). Jat 5:20 Navicat for Postgresql is native speed and good in may way of connection/reach to psql on remote side. Another option could be PHPPgAdmin if you're really stuck. Jat 3:54 I don't know of any unfortunately, I stick to the CLI. Very nice! First time I've tried postgres (outside of heroku), mostly because it was no hassle. There just doesn't seem to be one good tool out there for working with multiple database products. Navicat has tools for all of the above, but they're insanely expensive. Base is pretty good, but only supports SQLite. Sequel Pro is my favorite DB GUI tools, but it only supports MySQL. Have you come across any good GUI tools for working with Postgres? PGAdmin is pretty sad and doesn't have a native OS X look. I'm collecting those together and will be posting with a grab-bag of useful links soon. While preparing for this post, I've found a lot of small, useful Ruby libraries that improve the Postgres experience. I also make references to Rebecca Black and Mister Mister. I spend a couple of minutes explaining what Postgres is, in case you're not familiar with it, and I use Mike Perham's awesome launchctl controller Lunchy to manage the starting and stopping of Postgres instead of the usual (and arcane) Apple tools. So, I present, a scrappy 13 minute video alternative to the above tutorial: I still wanted to bring something to the table despite Will's work so I asked if I could make a screencast that roughly followed the same lines as his tutorial and he was up for it. installation (super simple with Homebrew).
SEQUEL PRO AND POSTGRES MAC OS X
It's entirely Mac OS X focused, so don't expect to enjoy it too much if you're on Linux or Windows! Will's post is a walkthrough of the process from sitting at an empty terminal prompt through to having a barebones Rails 3 app running on a Postgres powered database. Setting up PostgreSQL for Ruby on Rails development on OS X by Will Jessop :-) The Article. Coincidentally, it turned out 37signals sysadmin Will Jessop was already working on one so, I present. Postgres) installation tutorial for Ruby Inside. I hang out in #nwrug on Freenode, the IRC channel of a Ruby user group here in the UK, and floated the idea of doing a PostgreSQL (a.k.a.
0 kommentar(er)
