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.
pip install aws-psycopg2
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.
./configure --prefix {path_to_postgresql_source} --without-readline --without-zlib
make
make install
setup.cfg
file with the following:
pg_config={path_to_postgresql_source/bin/pg_config}
static_libpq=1
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.