No luck getting psycopg2 to work on AWS Lambda. about awslambda-psycopg2 HOT 3 CLOSED

hey @crowdwave, I've been working with Lambda recently and used this package to help me get psycopg on my functions.

I took one of my zipped uploads and stripped out my handler code and re-zipped it up and put it on my google drive, you can find the file here: sample_lambda_zip

Hopefully you can modify that handler and see if you can get your code to work. The other thing that I would watch out for is making sure that your Lambda function has network access to your DB.

For example, I host my postgres database using RDS, and I had to add my Lambda function to the RDS vpc and make sure that the routing rules supported incoming requests to it. By default, lambda functions usually get placed in their own VPC, so definitely double check that. I had some troubles there as well when I initially was getting this up and running.

from awslambda-psycopg2.

@phouse you are a life saver than you so much - I spent a ridiculous amoutn of time trying to fix the wrong problem - it was the vpc configuration of the lambda function all along.

Thanks massively for your help - once I had known good code I was forced to think of what else it could be.

from awslambda-psycopg2.

@crowdwave glad it worked out 👍

from awslambda-psycopg2.