Why can't I connect to my Amazon RDS database?
I simply cannot figure out how to access my RDS database through pgAdmin4.
More info:
-
The database is available;
-
The database is publicly accessible;
-
The database is part of a security group which allows all in-bound and out-bound traffic from anywhere (I know it's not good practice but it's only for the sake of making this work);
-
The credentials that I'm using are correct (host name, port, username, password);
-
It doesn't work to telnet to the database from the Windows CLI.
-
The route table points to an internet gateway.
-
It's associated with 3 subnets. All subnets have the following rules for both in-bound and out-bound: [100 All traffic All All 0.0.0.0/0 Allow] [* All traffic All All 0.0.0.0/0 Deny]
- Newest
- Most votes
- Most comments
Probably a silly question, but the RDS instance has been provisioned with a public IP address, and it's the public IP address that you're trying to connect to?
The route table points to an internet gateway.
It's associated with 3 subnets.
The route table needs to be associated to all three subnets. Do all three subnets each have a route table with a route to the Internet Gateway?
Relevant content
- asked 8 months ago
- Accepted Answerasked 13 days ago
AWS OFFICIALUpdated 9 months ago- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated a year ago
Thank you for the insight. The issue was that the subnets were connected to the internet. Only a EC2 machine was connected directly to the internet, and I thought that since the RDS database was connected to the EC2 machine, it made it accessible from the internet (in reality it didn't).