Skip to main content

A aws psycopg2 package from psycopg2.

Project description

psycopg2 Python Library for AWS Lambda

This is a custom compiled psycopg2 C library for Python. Due to AWS Lambda missing the required PostgreSQL libraries in the AMI image, we needed to compile psycopg2 with the PostgreSQL libpq.so library statically linked libpq library instead of the default dynamic link.I am just using the follwing git source and uploaded to https://pypi.org/

Install and setup

pip install aws-psycopg2

Source code : https://github.com/jkehler/awslambda-psycopg2/tree/master/psycopg2

Instructions on compiling this package from scratch

Here was the process that was used to build this package. You will need to perform these steps if you want to build a newer version of the psycopg2 library.

  1. Download the PostgreSQL source code and extract into a directory.
  2. Download the psycopg2 source code and extract into a directory.
  3. Go into the PostgreSQL source directory and execute the following commands:
  • ./configure --prefix {path_to_postgresql_source} --without-readline --without-zlib
  • make
  • make install
  1. Go into the psycopg2 source directory and edit the setup.cfg file with the following:
  • pg_config={path_to_postgresql_source/bin/pg_config}
  • static_libpq=1
  1. Execute python setup.py build in the psycopg2 source directory.

After the above steps have been completed you will then have a build directory and the custom compiled psycopg2 library will be contained within it. Copy this directory into your AWS Lambda package and you will now be able to access PostgreSQL from within AWS Lambda using the psycopg2 library.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for awslambda-psycopg2, version 1.0.2
Filename, size File type Python version Upload date Hashes
Filename, size awslambda_psycopg2-1.0.2-py3-none-any.whl (43.2 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size awslambda-psycopg2-1.0.2.tar.gz (34.3 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page