Common Errors When Installing postgres SQL and Ruby on Rails

I was setting up my local development environment for Podcastinople on my new Vista install and ran into some problems that I was able to find hidden deep in Ruby and Postgres forums and list archives.

One problem I had was that when I was creating some of my local postgres databases using a normal windows command prompt, this would cause it to spit out: psql: FATAL: password authentication failed for user ‘Rob’. ‘Rob’ is the name of my Windows Vista username, and shouldn’t have been a part of any postgres SQL operation, so I was confused.

Then I realized that I needed to be running psql to ‘postgres’ which is an installed shortcut with postgres. Continue reading Common Errors When Installing postgres SQL and Ruby on Rails