notes: postgis-15 would not work with deb

[wasdee]

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