On Heroku, I installed the new heroku-postgresql dev version, moving from the traditional shared-database.
$ heroku addons:add heroku-postgresql:dev
----> Adding heroku-postgresql:dev to myapp... done, v5 (free)
Attached as HEROKU_POSTGRESQL_SILVER
Database has been created and is available
! WARNING: dev is in beta
! increased risk of data loss and downtime
! send feedback to [email protected]
$ heroku pg:info HEROKU_POSTGRESQL_SILVER
=== HEROKU_POSTGRESQL_SILVER
Plan Dev
Status available
Connections 1
PG Version 9.1.3
Created 2012-06-01 14:23 UTC
Data Size 0
Tables 0
Rows 0
Conn Info "host=ec2-xx-xx-xxx-xxx.compute-1.amazonaws.com
port=5432 dbname=xxxxxxxxxxx
user=xxxxxxxxxx sslmode=require
password=xxxxxxxxxxxxxxxxx"
$ heroku pg:promote HEROKU_POSTGRESQL_SILVER
-----> Promoting HEROKU_POSTGRESQL_SILVER to DATABASE_URL... done
That’s all about trying out Heroku heroku-postgresql from the Gemba.
That’s all from the Gemba.