Skip to content

Instantly share code, notes, and snippets.

@hank-cp
Last active November 19, 2025 14:02
Show Gist options
  • Select an option

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

Select an option

Save hank-cp/f99d8137b6d49ed0503bf6dee15643b1 to your computer and use it in GitHub Desktop.
postgres-skr-Dockerfile
ARG PG_CONTAINER_VERSION=16.11
FROM hankcp/postgres-ext:${PG_CONTAINER_VERSION}
LABEL maintainer="[email protected]"
RUN pig ext add http -y \
-- && pig ext add pg_background -y \
&& pig ext add vector -y \
&& pig ext add pgtap -y \
&& pig ext add mysql_fdw -y \
&& pig ext add emaj -y
RUN echo ">>>>>>>> Setup build env <<<<<<<<" \
&& apt install -y libkrb5-dev libgssapi-krb5-2 build-essential cmake libpq-dev postgresql-server-dev-16
RUN echo ">>>>>>>> Build pg_background <<<<<<<<" \
&& cd /opt/ \
&& git clone https://github.com/hank-cp/pg_background.git \
&& cd pg_background \
&& make install \
&& echo ">>>>>>>> Build pg_vector_embedding <<<<<<<<" \
&& cd /opt/ \
&& git clone https://github.com/hank-cp/pg_vector_embedding.git \
&& cd pg_vector_embedding \
&& make install \
&& echo ">>>>>>>> Build pg_op_log <<<<<<<<" \
&& cd /opt/ \
&& git clone https://github.com/hank-cp/pg_op_log.git \
&& cd pg_op_log \
&& make install \
&& echo ">>>>>>>> Build pg_jieba <<<<<<<<" \
&& cd /opt/ \
&& git clone --depth 1 https://github.com/jaiminpan/pg_jieba \
&& cd pg_jieba \
&& git submodule update --init --recursive --depth 1 \
&& mkdir build && cd build \
&& cmake -DCMAKE_PREFIX_PATH="/usr/share/postgresql/16" -DPostgreSQL_TYPE_INCLUDE_DIR="/usr/include/postgresql/16/server" .. && make && make install
EXPOSE 5432
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment