AWS Lambda not able to connect to public RDS instance

Question

I have a public RDS instance running postgres. I can connect to it from my local host. The same function fails when I try to run it on lambda. The error I get is

***could not translate host name  to address: Name or service not known
"
***
There is no VPC associated with the lambda function. I can connect using psq -h  from my machine. Could you please suggest on how to resolve this?

Answer

I had a similar problem, which I solved with the following steps.

I created a new RDS instance in the management console.
At this time, I specified that a new VPC, subnet group, and security group be created as well.

In this case, a rule was created with the source IP "90.149.145.179/32" as an inbound rule for the security group.
In this state, I could still connect from the local PC, but not from Lambda.
When I changed the source IP to 0.0.0.0.0/0, I was able to connect from Lambda.

AWS Lambda not able to connect to public RDS instance

Relevanter Inhalt