Skip to content

Instantly share code, notes, and snippets.

@hank-cp
Created November 1, 2025 02:12
Show Gist options
  • Select an option

  • Save hank-cp/7b6b77ce03e630a325811d647fabe7dc to your computer and use it in GitHub Desktop.

Select an option

Save hank-cp/7b6b77ce03e630a325811d647fabe7dc to your computer and use it in GitHub Desktop.
postgres-ext-Dockerfile
ARG PG_CONTAINER_VERSION=17.6
FROM postgres:${PG_CONTAINER_VERSION}-bookworm
ARG PLV8_BRANCH=r3.2
ENV PLV8_BRANCH=${PLV8_BRANCH}
ARG PLV8_VERSION=3.2.4
ENV PLV8_VERSION=${PLV8_VERSION}
LABEL maintainer="[email protected]"
RUN apt-get update \
&& apt-get install -y curl sudo pipx git \
&& apt-get clean \
&& git config --global http.sslverify "false" \
&& echo ">>>>>>>> Build pigsty <<<<<<<<" \
&& curl -fsSL https://repo.pigsty.cc/pig | bash \
&& pig repo add pigsty -u \
&& echo ">>>>>>>> Build pxgn <<<<<<<<" \
&& pipx install pgxnclient \
&& export PATH=$PATH:/root/.local/bin \
&& echo ">>>>>>>> Build plv8 <<<<<<<<" \
&& pig ext add plv8 \
RUN sed -i "/en_US.UTF-8/s/^# //g" /etc/locale.gen && locale-gen
ENV LANG en_US.UTF-8
ENV LANGUAGE en_US:en
ENV LC_ALL en_US.UTF-8
EXPOSE 5432
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment