Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
175 views
in Technique[技术] by (71.8m points)

PGAdmin Query Tool Unable to Connect to Heroku DB

Apologies if this has already been answered, I saw a thread with similar topic but no proposed solutions.

After speaking with Heroku support, I believe the issue resolves around port access - they use 5432 as the default connection (tested on my end and is open), but I think 5000 as well for the Query tool (not open, blocked by npnp). Any ideas/advice is appreciated!

A few confirmation points:

  • I have tried both the October 2020 and Dec 2020 releases of pgAdmin - same issue
  • I Have tried the solution offered in this other post (configuring Query Tool to open in new tab) - same issue
  • I used nmap to test port status - port 5432 connected to postgresql, port 5000 closed w/ upnp
  • Interestingly, the main tool connects to the db just fine and can view the schema, just the Query Tool is having issues
  • I have tried accessing on different computer, same wifi network - and it actually works
  • I have not tried direct CLI access/querying, not exactly sure how
question from:https://stackoverflow.com/questions/65887932/pgadmin-query-tool-unable-to-connect-to-heroku-db

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...