terryjray

class Product < ActiveRecord::Base

  # our hstore column, make sure gem 'activerecord-postgres-hstore' is in your Gemfile
  # and you've run: rails g hstore:setup 
  serialize :data, ActiveRecord::Coders::Hstore

  # name is a string col
  attr_accessible :data, :name

  def self.search(query)

terryjray

# add or un-comment these mods in the /etc/httpd/conf/httpd.conf

ProxyRequests Off
ProxyPreserveHost On

<Proxy *>
 Order deny,allow
 Allow from all
</Proxy>

terryjray

RAILS_ENV=production rake db:setup
# produces the error below.....hmmm.....it's a no-worky
psql:/yourprojectpath/yourproject/db/structure.sql:29: ERROR:  could not open extension control file "/usr/share/postgresql/9.1/extension/hstore.control": No such file or directory

# hstore postgresql extension needs to be installed, so....
sudo apt-get install postgresql-contrib

# now your extension should be available to enable so log in with psql
psql -d yourproject_production -U yourdbuser -W