You need to install the postgres and/or ruby-postgres gems. I'm not
sure if both are needed as I've had it installed for a while now and
can't remember. Beyond that, I believe the adapter name in the
database.yml file should be postgresql not just postgres.