Using psycopg2 with Lambda to Update Redshift (Python)

by

In order for this to work you need to build psycopg2 with statically linked libpq.so library. Check out this repo https://github.com/jkehler/awslambda-psycopg2. It has already build psycopg2 package and instructions how to build it yourself.

Back to your questions:

What is causing this problem?

psycopg2 needs to be build an compiled with statically linked libraries for Linux.

Does it matter that Lambda uses Python 2.7 when I use 3.4?

Yes it does, lambda only supports 2.7 version. Just create virtual environment and install all necessary packages in there.

Does it matter that I zipped the contents of my file on a Windows machine?

As long as all the libraries you zipped could ran on Linux it doesn’t

Has anyone been able to successfully connect to Redshift from lambda?

yes.

More Related Contents:

  1. Using moviepy, scipy and numpy in amazon lambda
  2. Use AWS Glue Python with NumPy and Pandas Python Packages
  3. Cannot use Requests-Module on AWS Lambda
  4. Using python Logging with AWS Lambda
  5. Import libraries in lambda layers
  6. Python request in AWS Lambda timing out
  7. AWS error from Python: No module named lambda_function
  8. Tesseract OCR on AWS Lambda via virtualenv
  9. How to write a file or data to an S3 object using boto3
  10. How to upload a file to directory in S3 bucket using boto
  11. Load S3 Data into AWS SageMaker Notebook
  12. How to save S3 object to a file using boto3
  13. Read file content from S3 bucket with boto3
  14. Error “Read-only file system” in AWS Lambda when downloading a file from S3
  15. Getting started with secure AWS CloudFront streaming with Python
  16. Amazon S3 boto – how to delete folder?
  17. Read a file line by line from S3 using boto?
  18. toomanyrequests: You have reached your pull rate limit. You may increase the limit by authenticating and upgrading
  19. Can I use boto3 anonymously?
  20. Pandas in AWS lambda gives numpy error
  21. Getting S3 objects’ last modified datetimes with boto
  22. How to specify credentials when connecting to boto3 S3?
  23. Open S3 object as a string with Boto3
  24. Getting PIL/Pillow 4.2.1 to upload properly to AWS Lambda Py3.6
  25. how to copy s3 object from one bucket to another using python boto3
  26. AWS Java SDK – Unable to find a region via the region provider chain
  27. Flask, SQLAlchemy : KeyError: ‘SQLALCHEMY_TRACK_MODIFICATIONS’
  28. Run manage.py from AWS EB Linux instance
  29. Download a folder from S3 using Boto3
  30. Recommended way to manage credentials with multiple AWS accounts?

Leave a Comment