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 !

已提问 2 年前2867 查看次数
2 回答
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
专家
已回答 2 年前
  • 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.

0

I was resolve this choosing the last version of Postgres engine when creating my RDS Postgres.

已回答 1 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则