Please read for an updated status on RailsCasts:
Learn more or hide this
GitHub User: xmejkal
So let's start by saying Thanks, Ryan, great cast, really helpful and all that jazz.. (I mean it though)
Just one difference I'd like to share that I encountered on a fresh Ubuntu 12.04 VPS installation following the instructions of this screencast. After installing postgres, and adding a project specific user with password, I also had to modify the pg_hba.conf (/etc/postgresql/9.1/main/pg_hba.conf) file to enable the md5 authentication method, so that rails is able to connect to it with user and password specified in database.yml. Details are easily googleable, just wanted to point it out..