Custom dockerfile to install extension from pgxn network into postgres

Dockerfile

FROM postgres:latest
# FROM debian:latest

# libpq-dev make gcc postgresql postgresql-dev-all

RUN apt-get update && \
    apt-get install -y \
        python3 \
        pipx \
        make \
        gcc \
        postgresql-server-dev-$(psql --version | awk '{print substr($3, 1, 2)}')

RUN pipx install pgxnclient

RUN /root/.local/bin/pgxn install temporal_tables