How to connect to RDS from DBeaver

Question

Hi,  
  
I realise that this must be a really dumb question, but I just can't find the answer to it. I created a postgres RDS; it is not publicly accessible. I added an inbound rule to the security group specifying my full IP. But when I try to connect from DBeaver, I just get told that the connection attempt timed out.  
When I look at the RDS in the AWS console at the "Connectivity & security" tab , I see a link to a vpc. I also see 1 inbound rules - the CIDR rule I created. It matches the IP I'm on. Please tell me what stupid thing I am doing wrong?  
  
Thanks,  
Paul

Answer

if it is not publicly accessible  -  I guess you need to connect to VPC first

Answer

Hi Paul,

If your RDS instance is not publicly accessible this means RDS doesn't assign a public IP address to the cluster/instance. Only Amazon EC2 instances and other resources inside the VPC can connect to your cluster/instance. In this case, no resources outside of the VPC can connect to it without extra configuration. For example, you can use VPC peering, an AWS Site-to-Site VPN connection, or an AWS Direct Connect connection to connect resources outside of the VPC to the database.

If it is publicly accessible then RDS assigns a public IP address to the cluster/instance. Amazon EC2 instances and other resources outside of the VPC can connect to your cluster/instance. Even when the database is publicly accessible, access to it is ultimately controlled by the security groups associated with it. Access isn't permitted if these security groups don't permit it.

How to connect to RDS from DBeaver

Contenuto pertinente