Connecting to postgres RDS instance with restricted network access?
Solution 1:
You will need to be inside the VPC - creating an instance within the same VPC will do it, as long as the security group attached to the RDS allows the VPC private subnet. Only other way would be if you have some type of VPN that allows access to the VPC, since the RDS does not have internet access, you need to go to it basically.