ADD alpine-minirootfs-3.23.4-x86_64.tar.gz / # buildkit

CMD ["/bin/sh"]

RUN /bin/sh -c apk add --no-cache bash curl openssh procps shadow su-exec tzdata musl-locales musl-locales-lang && rm -rf /var/cache/apk/* # buildkit

RUN /bin/sh -c addgroup -S postgres && adduser -S -G postgres -h /var/lib/postgresql -s /bin/bash postgres && addgroup -S wal-g && adduser -S -G wal-g -s /bin/bash wal-g && adduser postgres wal-g # buildkit

RUN /bin/sh -c mkdir -p /usr/lib/postgresql/bin /usr/lib/postgresql/share/postgresql /usr/share/postgresql /var/lib/postgresql/data /var/log/postgresql /var/run/postgresql /etc/postgresql /etc/postgresql-custom && chown -R postgres:postgres /usr/lib/postgresql /var/lib/postgresql /usr/share/postgresql /var/log/postgresql /var/run/postgresql /etc/postgresql /etc/postgresql-custom # buildkit

COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit

COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit

COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit

COPY ansible/files/postgresql_config/conf.d /etc/postgresql-custom/conf.d # buildkit

COPY ansible/files/postgresql_config/postgresql-jsonlog.conf /etc/postgresql/logging.conf # buildkit

COPY ansible/files/postgresql_config/supautils.conf.j2 /etc/postgresql-custom/supautils.conf # buildkit

COPY ansible/files/postgresql_extension_custom_scripts /etc/postgresql-custom/extension-custom-scripts # buildkit

COPY ansible/files/postgresql_config/custom_walg.conf /etc/postgresql-custom/wal-g.conf # buildkit

COPY ansible/files/postgresql_config/custom_read_replica.conf /etc/postgresql-custom/read-replica.conf # buildkit

COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit

RUN /bin/sh -c sed -i -e "s|#unix_socket_directories = '/tmp'|unix_socket_directories = '/var/run/postgresql'|g" -e "s|#session_preload_libraries = ''|session_preload_libraries = 'supautils'|g" -e "s|#include = '/etc/postgresql-custom/supautils.conf'|include = '/etc/postgresql-custom/supautils.conf'|g" -e "s/ timescaledb,//g" -e "s/ pgsodium,//g" -e "s/db_user_namespace = off/#db_user_namespace = off/g" -e "s|^data_directory |#data_directory |g" /etc/postgresql/postgresql.conf && echo "pgsodium.getkey_script= '/usr/lib/postgresql/bin/pgsodium_getkey.sh'" >> /etc/postgresql/postgresql.conf && echo "vault.getkey_script= '/usr/lib/postgresql/bin/pgsodium_getkey.sh'" >> /etc/postgresql/postgresql.conf && chown -R postgres:postgres /etc/postgresql-custom && mkdir -p /usr/share/postgresql/extension/ && ln -s /usr/lib/postgresql/bin/pgsodium_getkey.sh /usr/share/postgresql/extension/pgsodium_getkey && chmod +x /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit

COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit

COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/init-scripts/00-schema.sql # buildkit

COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/migrations/00-extension.sql # buildkit

ENV PGDATA=/var/lib/postgresql/data

ENV POSTGRES_HOST=/var/run/postgresql

ENV POSTGRES_USER=supabase_admin

ENV POSTGRES_DB=postgres

ENV POSTGRES_INITDB_ARGS=--allow-group-access --locale-provider=icu --encoding=UTF-8 --icu-locale=en_US.UTF-8

ENV LANG=en_US.UTF-8

ENV LANGUAGE=en_US:en

ENV LC_ALL=en_US.UTF-8

ENV GRN_PLUGINS_DIR=/usr/lib/groonga/plugins

COPY /nix /nix # buildkit

COPY /tmp/groonga-plugins/plugins /usr/lib/groonga/plugins # buildkit

COPY /usr/local/bin/gosu /usr/local/bin/gosu # buildkit

RUN /bin/sh -c for f in /nix/var/nix/profiles/default/bin/*; do ln -sf "$f" /usr/lib/postgresql/bin/ 2>/dev/null || true; ln -sf "$f" /usr/bin/ 2>/dev/null || true; done && ln -sf /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ 2>/dev/null || true && ln -sf /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ 2>/dev/null || true && ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets 2>/dev/null || true # buildkit

RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql && chown -R postgres:postgres /usr/share/postgresql # buildkit

COPY docker/pgctld/postgresql.conf.tmpl /etc/pgctld-custom/postgresql.conf.tmpl # buildkit

COPY docker/pgctld/pgctld-wrapper /usr/local/bin/pgctld # buildkit

ENV POSTGRES_CONFIG_TEMPLATE_PATH=/etc/pgctld-custom/postgresql.conf.tmpl

RUN /bin/sh -c sed -i 's/ timescaledb,//g; s/ plv8,//g' /etc/postgresql-custom/supautils.conf # buildkit

RUN /bin/sh -c set -e && manifest=/docker-entrypoint-initdb.d/multigres-init.sql && printf -- "-- Auto-generated: run init-scripts and migrations after initdb\n" > "$manifest" && printf "DO \$\$ BEGIN\n IF NOT EXISTS (SELECT FROM pg_roles WHERE rolname = 'postgres') THEN\n CREATE ROLE postgres SUPERUSER LOGIN;\n END IF;\nEND \$\$;\n" >> "$manifest" && printf "ALTER DATABASE postgres OWNER TO postgres;\n\n" >> "$manifest" && printf "SET SESSION AUTHORIZATION postgres;\n" >> "$manifest" && for f in $(ls /docker-entrypoint-initdb.d/init-scripts/*.sql 2>/dev/null | sort); do printf '\\ir init-scripts/%s\n' "$(basename "$f")" >> "$manifest"; done && printf "\nRESET SESSION AUTHORIZATION;\n\n" >> "$manifest" && for f in $(ls /docker-entrypoint-initdb.d/migrations/*.sql 2>/dev/null | sort); do printf '\\ir migrations/%s\n' "$(basename "$f")" >> "$manifest"; done && chown postgres:postgres "$manifest" # buildkit

ENV POSTGRES_INITDB_SQL_FILES=/docker-entrypoint-initdb.d/multigres-init.sql

ENV PATH=/nix/var/nix/profiles/default/bin:/usr/lib/postgresql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

ENV LOCALE_ARCHIVE=/nix/var/nix/profiles/default/lib/locale/locale-archive

HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost || true"] "30s" "5s" "10s" "0s" '\x03'}

STOPSIGNAL SIGINT

USER postgres

EXPOSE map[5432/tcp:{}]

ENTRYPOINT ["tail"]

CMD ["-f" "/dev/null"]