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 与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
