postGIS on Heroku

When using postGIS on Heroku, you need to change the DATABASE_URL config var to postgis:// instead of the default postgres://

This is done by

heroku config:add DATABASE_URL='postgis://user:password@host.compute-1.amazonaws.com:port/dbname'

WARNING
This does interfere with addons, such as pgBackups.