You DRY with respect to username, password and connection parameters.
On production (both heroku and capistrano) you replace database.yml so it doesn't matter what is defined as production:. It can be used for production enviroment debugging on development though.
Usually the only configuration that differs between environments is the database name.
production:. It can be used for production enviroment debugging on development though.