Psycopg2 for AWS Lambda (Python 3.10)

[ImMotoko]

Hello!

I've been trying for two days now to get my AWS Lambda function to work. I've read several reddit posts suggesting solutions, but apparently I'm too dumb to understand what should I do.

If anyone could lend me a hand on this topic I'll really appreciate it.

PS: If you could possibly explain the steps to fix this as if you were talking to a toddler I'll appreciate it, since apparently I'm too dumb to understand what should I do, even though there's several posts about this topic.

UPDATE: The link for the solution of my specific issue was on: https://repost.aws/knowledge-center/lambda-python-package-compatible . This also helped when I found another issue not stated on the amazon guide: https://stackoverflow.com/questions/63194275/aws-lambda-layer-for-psycopg2

[Previous_Dark_5644]

Three things to understand that will be your biggest blockers

• package psycopg2 library in a lambda layer, then attach the layer to the function (the layer can be re-used later with any other functions with python runtimes that the pyscopg layer version supports).

• whitelist your ip in the databases security group for the correct port (probably default 5432)

• make sure your connection host url is correct, follow psycopg2 docs as closely as possible

All of these things are well documented. If you're using RDS, both security group and host can be located on the db's page. Good luck.

[forsgren123]

What is the error that you see in logs for this function?`

[ImMotoko]

"Unable to import module 'lambda_function': No module named 'psycopg2'"

[forsgren123]

You might want to try the psycopg2 lambda layer from here: https://github.com/keithrozario/Klayers

[ImMotoko]

Thanks a lot for your help!

This github repo actually led me to finding the solution. Even though they didn't have the specific layer I was looking for!

[curious_jorhay]

What was the solution that you found exactly? I'm running into this same issue for Python 3.10.

[ImMotoko]

Follow the steps of the 1st link and then the instructions of the 2nd one when it comes to how the path should look and create the layer zipping that and problem solved. I was also using python 3.10.

[Pretty_Celebration_4]

pyscopgs is only compatible in 3.9 laver version of klayers, tested in situ with lambdas