A (silly) PostgreSQL gotcha
As I was setting up my latest project in Rails 3 with PostgreSQL, Cucumber, RSpec and various other goodies, I got this error when running rake db:migrate:
PGError: ERROR: permission denied for relation schema_migrations SELECT version FROM schema_migrations
I took a quick look in my config/database.yml
And saw the following ridiculousness:
development: adapter: postgresql encoding: unicode database: myproject_development host: localhost pool: 5 username: password: productionpassword
Updating username to myproject and password to be blank did the trick.