Ruby on Rails

Use the 'pg' gem:

  gem 'pg'

And in config/database.yml:

  development:
    adapter: postgresql
    database: my_checkins_development
    host: localhost

Taken from a tutorial on my website: http://lassebunk.dk/2011/09/10/creating-a-location-aware-website-using-ruby-on-rails-and-postgis/

/Lasse

Once I changed the adapter to the correct string (postgresql) it worked great.
But I ran into a slightly different question.

I'm struggling with UTF-8 encoding and was wondering if:
1) there is any real difference in postgresql between setting up en_US.UTF-8 and POSIX as far as being able to read/write anything?  I'm thinking the answer is no.
2) when rails creates this database, is there some way I can add options to this yaml file to specify the encoding when it's created?