Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem connecting to heroku #54

Closed
meatballs opened this issue Sep 12, 2018 · 3 comments
Closed

Problem connecting to heroku #54

meatballs opened this issue Sep 12, 2018 · 3 comments

Comments

@meatballs
Copy link

Possibly related to #32

When I try to connect to a db hosted at heroku, I get the "no pg_hba.conf entry for host ...." error both in the db explorer and when I try to run a script.

I have other clients (PGAdmin and Oracle SQL Developer) on my laptop (Mac) which connect ok and I can execute queries from them.

@Borvik
Copy link
Owner

Borvik commented Sep 12, 2018

I have just attempted a connection to a Heroku database, successfully.

Here are the connection details I used - following the database settings page on Heroku:

{
  "label": "Heroku Test",
  "host": ".........compute-1.amazonaws.com",
  "user": ".........",
  "port": 5432,
  "certPath": "/home/...../image012.png",
  "database": ".......",
  "password": "......."
}

Database must be set - it can't enumerate them.
Also currently certPath must be set (can be something other than an actual certificate) - this triggers SSL mode, which is required for Heroku.

@meatballs
Copy link
Author

aggghhhhhh!!! It was the certificate path.

Thank you!

@Borvik
Copy link
Owner

Borvik commented Sep 12, 2018

No problem.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants