Heroku: How to connect the database through navicat
amazon-web-services, django, heroku
Solution
Assuming that's not a real Database URL you've posted and you're using the Heroku Shared 9.1 Beta addon (https://postgres.heroku.com/blog/past/2012/4/26/heroku_postgres_development_plan/ - which is the only shared DB that will let you connect externally you'd just split into the relevant parts
postgres://sfbywaqhvj:_WgTgP660aDnYuS3aP3o@ec2-23-21-64-4.compute-1.amazonaws.com/sfbywaqhvj
becomes
Username: sfbywaqhvj
password: _WgTgP660aDnYuS3aP3o
host: ec2-23-21-64-4.compute-1.amazonaws.com
database: sfbywaqhvj
Problem
I have deploy a Helloworld django App on Heroku, and a shared database is generated ,My DATEBASE_URL is `postgres://sfbywaqhvj:_WgTgP660aDnYuS3aP3o@ec2-23-21-64-4.compute-1.amazonaws.com/sfbywaqhvj` Can I connect the db through navicat or other local DBMS? THX