1

I am fairly new to AWS, so I am sure that I am just missing something, but here is my problem:

I have created a VPC with 3 subnets and one security group linked to all of them. The security group accepts inbound from my machine. Next I have created to RDS (both PostgreSQL) into that VPC and added linked them to the VPC security group. Weirdly, I can only connect to one of them, for the other one I get a generic error.

Any idea on what I am missing? I can share any more details if needed.

Lennart
  • 11
  • 1

1 Answers1

1

My guess is that either both RDS don't have the same / correct Security Group, or the VPC subnets have different route tables that prevent access to one of the RDS instances.

MLu
  • 24,849
  • 5
  • 59
  • 86
  • Hi, thank you for your comment! They actually have the exact same security groups and subnets. Which is why I am so confused. – Lennart Apr 10 '19 at 09:34
  • @Lennart when you say the other one returns “generic error” what does that mean? Can you provide a screenshot? – MLu Apr 10 '19 at 09:38
  • Message is as follow: could not connect to server: Connection timed out. Is the server running on host "******.rds.amazonaws.com" (**.***.**.***) and accepting TCP/IP connections on port 5432? – Lennart Apr 10 '19 at 09:41
  • @Lennart as noted in the answer, all the subnets also need the same route table if they are all used for the same purpose. Confirm this? – Michael - sqlbot Apr 10 '19 at 18:50
  • Yes, same route table for all subnets. The two DBs are using the same subnets though. Can that be a problem? – Lennart Apr 11 '19 at 01:10