FROM postgres:16-alpine

ENV POSTGRES_HOST_AUTH_METHOD=trust
ENV LD_LIBRARY_PATH=/opt/lib

RUN mkdir -p /opt/lib && mv /usr/local/lib/libpq.so* /opt/lib

# This causes dlopen(libpqwalreceiver.so)
COPY <<-EOF /docker-entrypoint-initdb.d/create-subscription.sql
  CREATE SUBSCRIPTION sub1
  CONNECTION 'dbname=doesnotexist' PUBLICATION pub1
  WITH (connect = false);
EOF