Database Credentials - PythonDeveloperNotes/heroku GitHub Wiki

Steps

  1. Click Overview -> Resources -> Heroku Postgres
  2. Click Settings -> Database Credentials

Example Only

Get credentials for manual connections to this database. Please note that these credentials are not permanent. Heroku rotates credentials periodically and updates applications where this database is attached.

Host: ec2-62-xx-xxx-xxx.compute-1.amazonaws.com

Database: x68ee43j2xxxxx

User: xbutrzbgyxxxxx

Port: 5432

Password: xxxxxc5ea9dc2894526a932c056629xxxxxxxxxxceac4689a1da6a0c3923d0c1xxxxx

URI: postgres://xbutrzbgyxxxxx:xxxxxc5ea9dc2894526a932c056629xxxxxxxxxxbf717ceac4689a1da6a0c3923d0c1xxxxx@ec2-62-xx-xxx-xxx.compute-1.amazonaws.com:5432/x68ee43j2xxxxx

Heroku CLI: heroku pg:psql postgresql-clear-71xxx --app my_project