Postgres 17

[OverHash]

Postgres 17 is now released. I'm not sure what the exact steps required are but it looks like a bump to the pg_version table and a new release cut at the minimum?

I tried to use the existing v16 extension in a postgres:17 container and didn't have success:

FROM postgres:17

# Copy the TypeID extension
# See https://github.com/blitss/typeid-postgres/pkgs/container/typeid-pg/240468201?tag=v0.1.0-docker
COPY --from=ghcr.io/blitss/typeid-pg@sha256:a758acf9d49183206bf513502db4cfe86996986841c012495989ac6d324fcae4 \
     /usr/lib/postgresql/16/lib/typeid.so /usr/lib/postgresql/17/lib/typeid.so
COPY --from=ghcr.io/blitss/typeid-pg@sha256:a758acf9d49183206bf513502db4cfe86996986841c012495989ac6d324fcae4 \
     /usr/share/postgresql/16/extension/typeid* /usr/share/postgresql/17/extension/

❯ docker exec -it postgres psql -U postgres -d database -c "CREATE EXTENSION IF NOT EXISTS typeid;"
ERROR:  incompatible library "/usr/lib/postgresql/17/lib/typeid.so": version mismatch
DETAIL:  Server is version 17, library is version 16.

[blitss]

Yep, would need to update dependencies for that and build a new version. Will probably do in the coming days

[blitss]

@OverHash I published new version that supports postgres@17, and also updated docs with new installation methods. Lmk if you will still experience any issues

[OverHash]

Nice! I think I tried it and it works on postgres:17. Unfortunately I don't think this repository supports alpine variants of postgres, so I had to build it myself. I wonder how hard it is to add support for that to this repository.

My Dockerfile to build support for the alpine variant (which uses musl and not glibc like the GitHub runner that creates the ghcr builds):

Dockerfile

FROM postgres:17-alpine AS builder

# install build deps + clang for bindgen
RUN apk add --no-cache \
      build-base \
      postgresql-dev \
      git \
      rust \
      cargo \
      clang \
      clang-dev \
      llvm-dev \
      # needed for pgrx-pg-sys
      rustfmt

# build via pgrx
WORKDIR /tmp

RUN git init typeid \
 && cd typeid \
# 2) Add remote and fetch only main (depth=1)
 && git remote add origin https://github.com/blitss/typeid-postgres.git \
 && git fetch --depth 1 origin main \
# 3) Fetch the specific commit (also shallow)
 && git fetch --depth 1 origin 8d2809be4e3190e9601189092a99ffac728ebcb2 \
# 4) Checkout that commit
 && git checkout 8d2809be4e3190e9601189092a99ffac728ebcb2

WORKDIR /tmp/typeid

RUN cargo install --locked --force cargo-pgrx \
 && cargo pgrx init --pg17 /usr/bin/pg_config \
 && cargo pgrx package --pg-config /usr/bin/pg_config

# copy extension files
RUN mkdir -p /usr/local/lib/postgresql /usr/local/share/postgresql/extension \
 && cp \
      target/release/typeid-pg17/usr/lib/postgresql17/typeid.so \
      /usr/local/lib/postgresql/ \
 && cp \
      target/release/typeid-pg17/usr/share/postgresql17/extension/typeid* \
      /usr/local/share/postgresql/extension/

# now build the Postgres image
FROM postgres:17-alpine
COPY --from=builder /usr/local/lib/postgresql/typeid.so \
     /usr/local/lib/postgresql/typeid.so
COPY --from=builder /usr/local/share/postgresql/extension/typeid* \
     /usr/local/share/postgresql/extension/