Cannot connect to RDS instance with PGAdmin

0

Hi, I've been connecting to a public RDS instance with pgAdmin for the past 2 years with no problems. Starting 2 weeks ago, I get a timeout error connecting to the same instance. Nothing has changed in the RDS configuration. Public Assessible is turned on. There are inbound rules of the vpc security group open on port 5432 for all IPs. I added a rule with my own IP just in case, but that doesn't help.
The website that query the postgres DB on this instance still works which means the DB is there and working, but its just pgAdmin that cannot connect to it. Can't figure out what is causing this. Help !

1 Answer
0

It could be that the version of the RDS Postgres database was upgraded recently and that has rendered the pgadmin version incompatible. Or else your pgadmin may have gotten corrupted for whatever reason. If you haven't tried it already, I would try reinstalling pgadmin and see if that helps.

We also have a Premium Support article that may help debug - https://aws.amazon.com/premiumsupport/knowledge-center/rds-cannot-connect/

profile pictureAWS
EXPERT
answered 2 years ago
  • Thanks for the reply. I downloaded the latest version of pgAdmin 4 and still getting the same timeout expired error.

  • Is the application that is working using the same username/password to connect to the database, as pgadmin? If not, make sure the password of the user was not modified. If the Security Group inbound rules are fine, I would also take a look at the security group outbound rules and also NACLs on the subnet to ensure nothing has changed recently. Can't think of any other reason why pgadmin would suddenly stop connecting to the database.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions