Connect to a heroku database with pgadmin

by

Open the “Properties” of the Heroku server in pgAdminIII and change the “Maintenance DB” value to be the name of the database you want to connect to.

pgAdmin III - New Server Registration

The default setup is suitable for DBAs et al who can connect to any database on the server, but apparently that isn’t true in your case.

More Related Contents:

  1. How can I import a .sql file into my Heroku postgres database?
  2. Keep PostgreSQL from sometimes choosing a bad query plan
  3. Copying PostgreSQL database to another server
  4. Primary keys with Apache Spark
  5. How can I put a database under git (version control)?
  6. How can I send email from PostgreSQL trigger?
  7. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  8. Change from SQLite to PostgreSQL in a fresh Rails project
  9. Store query result in a variable using in PL/pgSQL
  10. Can I rollback a transaction I’ve already committed? (data loss)
  11. Kill a postgresql session/connection
  12. PostgreSQL: Drop PostgreSQL database through command line [closed]
  13. Do stored procedures run in database transaction in Postgres?
  14. Import SQL dump into PostgreSQL database
  15. how to use Blob datatype in Postgres
  16. How can I solve Postgresql SCRAM authentication problem?
  17. Convert SQLITE SQL dump file to POSTGRESQL
  18. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  19. How to login and authenticate to Postgresql after a fresh install?
  20. How do you write a case insensitive query for both MySQL and Postgres?
  21. PostgreSQL Database Log Transaction
  22. How do I automatically update a timestamp in PostgreSQL
  23. Starting and populating a Postgres container in Docker
  24. Adding a new value to an existing ENUM Type
  25. Backup/Restore a dockerized PostgreSQL database
  26. Should each and every table have a primary key?
  27. When and why are database joins expensive?
  28. XML data to PostgreSQL database [closed]
  29. Best representation of an ordered list in a database?
  30. Creating test data in a database [closed]

Leave a Comment