amazon web services - Trying to let my lambda access an RDS database (postgres) but when creating database proxy the "RDS DB Instance" is empty

Question

I created an RDS postgres database with public access. I can connect to it from SQL Workbench and perform SQL queries. Now I want to build a lambda to query data from my database.

Following the instructions from https://docs.aws.amazon.com/lambda/latest/dg/configuration-database.html

In this screen: https://imgur.com/yUsyGRQ

If I open the "RDS DB instance" drop down my database is not there.

What have I done wrong?

Thanks

question from:https://stackoverflow.com/questions/65652313/trying-to-let-my-lambda-access-an-rds-database-postgres-but-when-creating-data

Answer 1

A common reason for that is using wrong PostgreSQL version. RDS proxy supports only some version:

For RDS PostgreSQL, RDS Proxy supports version 10.10 and higher minor versions, and version 11.5 and higher minor versions. For Aurora PostgreSQL, RDS Proxy supports version 10.11 and higher minor versions, and 11.6 and higher minor versions.

Thus, if you use newest version PostgreSQL 12, RDS proxy will not show it as its not supported.

You still can use this db from lambda, but have to associate your function with the VPC where RDS is and setup security groups so that function can connect to the db.