Hi there,
I’m having an issue with Pgadmin and I’d appreciate some input as I cannot find anything online!
I am using Pgadmin as a frontend to maintain a Postgresql database hosted on Heroku. If I connect to the database from my home wifi connection, it connects successfully. It also connects successfully if I tether using my mobile phone. However if I use my university’s student WiFi, I cannot connect and I get the following error:
could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host <HOSTNAME> (<IP ADDRESS>) and accepting TCP/IP connections on port 5432?
How do I even begin to troubleshoot this? I have checked that Pgadmin has permission in my firewall (it does), and I have checked that port, username, host, and password are correct (which they are as it works from home). I thought maybe the port was blocked, so I used an online port checker – while it DID say port 5432 was closed on my university WiFi it also says this when tethered with my phone – but the connection DOES work on my phone.
I really need this to be working, as it means that I cannot access the database from within university – pointless as it is part of my course to do so!
Thanks,
Sam
This email and any attachments are confidential and intended solely for the use of the addressee and may contain information which is covered by legal, professional or other privilege. If you have received this email in error please notify the system manager at postmaster@ulster.ac.uk and delete this email immediately. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Ulster University.
The University's computer systems may be monitored and communications carried out on them may be recorded to secure the effective operation of the system and for other lawful purposes. Ulster University does not guarantee that this email or any attachments are free from viruses or 100% secure. Unless expressly stated in the body of a separate attachment, the text of email is not intended to form a binding contract. Correspondence to and from the University may be subject to requests for disclosure by 3rd parties under relevant legislation.
The Ulster University was founded by Royal Charter in 1984 and is registered with company number RC000726 and VAT registered number GB672390524.The primary contact address for Ulster University in Northern Ireland is Cromore Road, Coleraine, Co. Londonderry BT52 1SA