- Newest
- Most votes
- Most comments
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/
Relevant content
asked 4 years ago
asked a year 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.