Question: What is the best way to get PLV8 in alpine image?

[owais]

It seems that postgresql-contrib does not ship PLV8 extension. Does Alpine have a package for PLV8 or is it best to manually build it at the moment?

[tianon]

The postgres:X.Y-alpine images compile PostgreSQL from source (

postgres/Dockerfile-alpine.template

Lines 69 to 112 in e7222bf

	&& cd /usr/src/postgresql \
	# update "DEFAULT_PGSOCKET_DIR" to "/var/run/postgresql" (matching Debian)
	# see https://anonscm.debian.org/git/pkg-postgresql/postgresql.git/tree/debian/patches/51-default-sockets-in-var.patch?id=8b539fcb3e093a521c095e70bdfa76887217b89f
	&& awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new \
	&& grep '/var/run/postgresql' src/include/pg_config_manual.h.new \
	&& mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h \
	&& gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)" \
	# explicitly update autoconf config.guess and config.sub so they support more arches/libcs
	&& wget -O config/config.guess "http://git.savannah.gnu.org/gitweb/?p=config.git;a=blob_plain;f=config.guess;hb=HEAD" \
	&& wget -O config/config.sub "http://git.savannah.gnu.org/gitweb/?p=config.git;a=blob_plain;f=config.sub;hb=HEAD" \
	# configure options taken from:
	# https://anonscm.debian.org/cgit/pkg-postgresql/postgresql.git/tree/debian/rules?h=9.5
	&& ./configure \
	--build="$gnuArch" \
	# "/usr/src/postgresql/src/backend/access/common/tupconvert.c:105: undefined reference to `libintl_gettext'"
	# --enable-nls \
	--enable-integer-datetimes \
	--enable-thread-safety \
	--enable-tap-tests \
	# skip debugging info -- we want tiny size instead
	# --enable-debug \
	--disable-rpath \
	%%UUID_CONFIG_FLAG%% \
	--with-gnu-ld \
	--with-pgport=5432 \
	--with-system-tzdata=/usr/share/zoneinfo \
	--prefix=/usr/local \
	--with-includes=/usr/local/include \
	--with-libraries=/usr/local/lib \
	\
	# these make our image abnormally large (at least 100MB larger), which seems uncouth for an "Alpine" (ie, "small") variant :)
	# --with-krb5 \
	# --with-gssapi \
	# --with-ldap \
	# --with-tcl \
	# --with-perl \
	# --with-python \
	# --with-pam \
	--with-openssl \
	--with-libxml \
	--with-libxslt \
	&& make -j "$(nproc)" world \
	&& make install-world \
	&& make -C contrib install \

), so yes, any extensions necessary should also likely be compiled from source. 👍

[deinspanjer]

There is also the image clkao/postgres-plv8 which I'm very happy with.

[JRileyH]

There is also the image clkao/postgres-plv8 which I'm very happy with.

Which is expressly not alpine.

[alexeyfadeev]

@owais @JRileyH
Look at our images (with Dockerfile links),
There are alpine-based versions as well.