Skip to content

Instantly share code, notes, and snippets.

@harokevin

harokevin/viewing_heroku_database_in_postico.md

Last active May 15, 2019 20:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save harokevin/f4c66e3df3c51b160e9b5ee7ff31bfba to your computer and use it in GitHub Desktop.
Save harokevin/f4c66e3df3c51b160e9b5ee7ff31bfba to your computer and use it in GitHub Desktop.
Download ZIP
Viewing Heroku database in postico
Raw
viewing_heroku_database_in_postico.md
  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