Fly.io Postgres w/ PGMQ

Dockerfile

FROM flyio/postgres-flex:16.4

RUN apt-get update && \
  apt-get install -y --no-install-recommends \
  git \
  build-essential \
  postgresql-server-dev-16 \
  unzip \
  curl && \
  cd /home && \
  curl -LO https://api.pgxn.org/dist/pgmq/1.4.5/pgmq-1.4.5.zip && \
  unzip pgmq-1.4.5.zip && \
  cd pgmq-1.4.5 && \
  make && \
  make install && \
  # Cleanup
  cd / && \
  rm -rf /home/pgmq* && \
  apt-get remove -y \
  git \
  build-essential \
  postgresql-server-dev-16 \
  unzip \
  curl && \
  apt-get autoremove -y && \
  apt-get clean && \
  rm -rf /var/lib/apt/lists/*