Score:0

Can't access RDS instance externally

eg flag

I've spun up an RDS postgres database in an existing VPC (which has both public and private subnets - connected to a NAT gateway) which I've set as publicly accessible.

I've added the relevant IP addresses to the attached security group, and this has allowed internal access from inside the VPC but not external access.

Struggling to figure out where to start looking for troubleshooting not being able to access the database externally from the safe-listed IPs.

I've run through the amazon troubleshooting guides (is it set to public? does the vpc have internet access inbound and outbound? have you added the right security group and IPs?) but still no luck.

nc: connect to eksdatabase[redacted].amazonaws.com port 5439 (tcp) failed: Connection timed out
Dennis Nolte avatar
us flag
Random uneducated guess: can you ping the servers from outside with the public IPs? Is there perhaps something you need to setup for port fowarding?
Michael Hampton avatar
cz flag
Welcome to [sf]. This is not a forum but a Q&A site. You are welcome to [answer your own question](/help/self-answer); remember that answers should be placed in the answer box below, as any other answer. If placed above, people will misinterpret it as part of the question and think your problem is not solved. After you post your answer below, you can then mark the problem as solved by clicking the outline of the tick mark so that it turns solid green.
Score:1
eg flag

I'm going to go ahead and answer my own question here for anyone else who finds themselves in this situation (probably not because you'll be smarter than I was) - Don't choose the default subnet group which includes all your private subnets... make a new subnet group with only your public subnets! Problem solved!

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.