[BUG] Python 3.11 > aws-psycopg2 >> "Unable to import module 'lambda_function': No module named 'psycopg2._psycopg'"

[panos4tw]

Describe the bug
I import the module as "import psycopg2" and then I tried to use it as "psycopg2.connect(conn_string)" with no success

Screenshots

Layer Version ARN:
arn:aws:lambda:eu-central-1:770693421928:layer:Klayers-p311-aws-psycopg2:1

Framework:
Console

Additional context

[keithrozario]

Can you share your full code? Is there a lambda_function.lambda_handler method somewhere here?

[panos4tw]

Code looks like this, it's the default AWS Lambda Python boilerplate. I ended up making a layer of my own to make this work:

[keithrozario]

Sorry to hear that, will look into this later this week.

[iliaaz]

Hi there! Just ran into the same issue - anything I can do to help debug?

[linusliu]

I also run into the same issue.
Add the following layer to a lambda function, python runtime version 3.11; architecture x86_64
arn:aws:lambda:us-east-1:770693421928:layer:Klayers-p311-aws-psycopg2:1

Will return error:
Response
{
"errorMessage": "Unable to import module 'lambda_function': No module named 'psycopg2._psycopg'",
"errorType": "Runtime.ImportModuleError",
"requestId": "a7956df2-4a44-40c0-a2ea-0ae0e7ca33b7",
"stackTrace": []
}

[austinulfers]

Getting the same issue with 3.12

[keithrozario]

HI Folks, can you try the latest layer. It 'hopefully' resolves the issue.

arn:aws:lambda:us-east-2:770693421928:layer:Klayers-p311-psycopg:10

Replace the region with the one you're using.

[austinulfers]

arn:aws:lambda:us-east-2:770693421928:layer:Klayers-p311-psycopg:10

Can confirm that I was able to get this to work on us-west-2.

[keithrozario]

Yay! Thanks @austinulfers

The fix was to pip install psycopg[binary,pool] which installs the binary as well. The previous installation only installed the library but not the libpq.so binary.

Thankfully this fixes it -- but I'll need to figure out how to incorporate this build with the optional dependencies.

[keithrozario]

Closing. Please re-open if this doesn't work.