Skip to content

Instantly share code, notes, and snippets.

@harokevin
Last active May 15, 2019 20:42
Show Gist options
  • Save harokevin/f4c66e3df3c51b160e9b5ee7ff31bfba to your computer and use it in GitHub Desktop.
Save harokevin/f4c66e3df3c51b160e9b5ee7ff31bfba to your computer and use it in GitHub Desktop.
Viewing Heroku database in postico
  1. Look in the config/environment variables on your heroku instance
  2. Find and Copy the DATABASE_URL
  • Example DATABASE_URL: postgres://fforjkfkc:7217307aa219000000000000000000000000000000000000000170828@ec2.compute.amazonaws.com:5432/jfkfc8kh7kh747o6g

  • Anatomy: postgres://[user]:[password]@[host]:[port]:[database]

  1. Open postico and add the user, password, host, and database.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment