How do I make sure my Heroku Postgres database credentials are correct?

Issue

You've accidentally changed your database credentials with heroku rollback or by directly editing a config var. You need to ensure your config vars have correct values that will get updated automatically in the future.

Resolution

You can verify your current credentials running heroku pg:credentials:url -a <app_name>.

You can also reset your credentials with the heroku pg:credentials:rotate command. That will create a new username and password for your database and update the associated config variable. If you have manually changed other config vars on this or another app, you can use the heroku addons:attach command to attach your database addon to the same app, or to another Heroku app.

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support