Rails 4 + Postgres + opsworks

gistfile1.md

##Create RDS with postgres

Opsworks has a bug, even you registerd a postgres RDS, the adapter is still using 'mysql'

WORKAROUND:

##Create mysql layer (fake) don't assign instances

##Use custom Stack JSON

*Be careful with adapter

{
  "deploy": {    
    "ticket_to_paradise": {
      "database": {
        "adapter": "postgis", 
        "encoding": "utf8",
        "host": "your-host",
        "port": "5432",
        "database": "attp_db_2",
        "pool": "5",
        "username": "your-password",
        "password": "your-username",
      }
    }
  }
}

##Add missing postgres package In OS package, Add postgresql93-devel

##Add security group -> opsworks-rails-layer.

Enable postgis extension

###login into psql

psql -h <host> -p <port> -u <database>

Add postgis extension

##Then db:migrate and db:seed

If you created your db before. time to drop it and recreate it!