shlogg · Early preview
Franck Pachot @franckpachot

Testing PostgreSQL Extensions Quickly With Docker And YugabyteDB

Test PostgreSQL extensions quickly on YugabyteDB by extracting files from a Docker image, saving time & effort in compilation.

In this series about PostgreSQL extensions on YugabyteDB here is a way to test quickly an extension by taking its files from a docker image. This is what I did to test Apache AGE.
The following starts a container from an image with PostgreSQL and the extension we want, and extract them into a tarball (I take files with pattern age* as I know those are the files from Apache AGE extension):

docker run --rm -i apache/age bash -c '
mkdir -p stage/share/extension stage/lib 
mv $(pg_config --pkglibdir)/age* stage/lib
mv $(pg_config --sharedir)/extension/age* stage/share/extension
tar -C stage -zcvf...