error while uploading python zip file with psycopg2 to aws lambda

Question

I'm trying to add the python zip files to was lambda which contains psycopg2 files in it.I'm getting an error. please try to help

  "errorMessage": "Unable to import module 'handler': libpq.so.5: cannot open shared object file: No such file or directory",
  "errorType": "Runtime.ImportModuleError"

Does this answer your question? Using psycopg2 with Lambda to Update Redshift (Python) — amsh
– amsh, Commented Oct 6, 2020 at 13:36

balderman · Accepted Answer · 2020-10-06 13:06:02Z

9

The point is psycopg2 depends on native code (libpq.so) and your zip file does not contain this dependency.

See here for a solution

Another option is pip install psycopg2-binary. See here for details.

answered Oct 6, 2020 at 13:06

balderman

24k8 gold badges39 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Destroy666 · Accepted Answer · 2023-09-26 08:39:41Z

0

Resolved this error on GitHub Actions with following code:

- name: Package Lambda function
  run: |
    mkdir package
    cp main.py package/
    pip install psycopg2-binary -t package/
    pip install -r requirements.txt -t package/
    cd package
    zip -r ../function.zip .
    cd ..

edited Sep 26, 2023 at 8:39

Destroy666

1,6002 gold badges19 silver badges26 bronze badges

answered Sep 19, 2023 at 19:11

poori G

91 bronze badge

Collectives™ on Stack Overflow

error while uploading python zip file with psycopg2 to aws lambda

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related