Skip to content

Postgresql 16.3 VERSION unable to connect using PgAdmin

0

I have created RDS instance which has public access but unable to connect it using pgAdmin, I have attached security group which has port 5432 open, getting connection timeout issue message in pgAdmin. Any solution for this

asked 2 years ago365 views

1 Answer
2

Hello.

What kind of rules are set in the inbound rules of the RDS security group?
For example, if you use pgAdmin to connect to RDS via the Internet, you will need to allow public IP addresses in the security group. Also, even if RDS is public access, if the subnet in which the RDS instance is launched is not a public subnet, you will not be able to connect to RDS via the Internet.
Therefore, please check whether a route to the Internet gateway is set in the route table of the subnet where RDS is running.

By the way, it is not recommended to set RDS for public access, so if you can use the port forwarding function of Systems Manager Session Manager, as introduced in the blog below, I think you should consider it.
https://aws.amazon.com/jp/blogs/mt/use-port-forwarding-in-aws-systems-manager-session-manager-to-connect-to-remote-hosts/

EXPERT

answered 2 years ago

EXPERT

reviewed 2 years ago

  • I have allow all traffic inbound rule, and i have selected default vpc which dont have NAT gateway, I am using for POC purpose thats why i keep public.

  • Is it possible to connect with the same settings when using a different version of RDS PostgreSQL?

  • I tried with different RDS postgres version but facing same issue.

  • By the way, can I access it from my local PC using something like psql command instead of pgAdmin? If this fails, there is a problem with the RDS security group or route table or network ACL. Also, check if you can check the public IP address when resolving the name of the RDS endpoint using the "dig" command. If you cannot confirm your public IP address, RDS is not enabled for public access.

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.