I am not sure if this is the part that author should taking care or not.
Here is a note for future dudes who stucks like me.
ERROR: could not load library "/usr/lib/postgresql/15/lib/ulid.so": /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.33' not found (required by /usr/lib/postgresql/15/lib/ulid.so)
SQL state: 58P01
The reason is that the GLIBC on image has 2.3.1 version and the requirement is 2.3.3.
Thus, the only way to use it is by compile only.
# PostGIS, but add ULID extension
ARG PG_MAJOR=15
FROM postgis/postgis:${PG_MAJOR}-3.3
RUN apt update
RUN apt-get install -y --no-install-recommends curl
RUN apt upgrade -y
RUN curl -OJL https://github.com/pksunkara/pgx_ulid/releases/download/v0.1.0/pgx_ulid-v0.1.0-pg15-amd64-linux-gnu.deb && \
apt install ./pgx_ulid-v0.1.0-pg15-amd64-linux-gnu.deb
WORKDIR /home/postgres
ENV HOME=/home/postgres
ENV PATH=/home/postgres/.cargo/bin:$PATH
RUN chown postgres:postgres /home/postgres
USER postgres
I am not sure if this is the part that author should taking care or not.
Here is a note for future dudes who stucks like me.
The reason is that the
GLIBCon image has 2.3.1 version and the requirement is 2.3.3.Thus, the only way to use it is by compile only.