plv8 migrations

docker image rewrite

For the transition period we need a docker image (and also an ec2 image) that has both python and plv8 extension installed.

Problems

• current image works, but the Dockerfile itself doesn't work anymore. latest successfuly build was 6 months ago
  • pip install requests doesn't work anymore
• I don't understand how the aws_s3 extension got into our image (see below)
  • the postgres base image doesn't have it
  • FelixD had the idea of using the specific versions of the installed stuff (apt/pip) that were current 6 months ago

aws_s3 extension

content of our current image

root@2be67e303e87:/# find . -name "*aws_s3*"
./usr/share/postgresql/14/extension/aws_s3.control
./usr/share/postgresql/14/extension/aws_s3--0.0.1.sql
./postgres_extension/postgres-aws-s3/aws_s3.control
./postgres_extension/postgres-aws-s3/aws_s3--0.0.1.sql

plv8

• this an up-2-date image of a postgres with plv8 (based on the postgres base image)

• installation instructions

what	where
installation instructions	https://plv8.github.io/#linux
up 2 date dockerfile	https://github.com/sibedge-llc/plv8-dockerfiles/blob/master/bookworm/Dockerfile