RE: Problems connecting PGAdmin to server
I think it’s more likely to be my university’s WiFi. I use the same computer at home as I do in university (my laptop). How do I check to make sure that Heroku isn’t blocking traffic?
So if I speak to my university’s IT department, what do I need to tell them? Is it just a case of opening that port, or do I need to do something else?
Thanks,
Samuel Holmes
PhD Researcher
T: 028 9036 8132
E: Holmes-W@ulster.ac.uk W: www.ulster.ac.uk
Social: Twitter: @SamuelH1982
LinkedIn: samuelholmes82
From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: 29 January 2018 16:03
To: Samuel Holmes <Holmes-W@ulster.ac.uk>
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: Problems connecting PGAdmin to server
On Mon, Jan 29, 2018 at 8:46 AM, Samuel Holmes <Holmes-W@ulster.ac.uk> wrote:
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.
Two simple possibilities:
Heroku is blocking on their (the server) side, not yours (the client).
The University is blocking outbound traffic on that port.
I suspect you can check and configure the first one; the second one you'd need to inquire with your university's IT department.
You are using the same machine at home and at the university? If so that should preclude it being your machine (though its possible your firewall has different settings when connected to the different wifi networks).
Online port checkers are prone to false negatives.
David J.
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
Вложения
В списке pgadmin-support по дате отправления:
Следующее
От: Michael RasmussenДата:
Сообщение: Select, Update, and Insert script generation fails to load