datapoint: I've been using PostgreSQL (and it's GIS extension PostGIS) with Rails for over a year now. Some minor issues along the way, but never ever going back to MySQL.