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

CMD ["/bin/sh"]

RUN /bin/sh -c apk add --no-cache bash curl 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

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 mkdir -p /usr/lib/postgresql/bin /usr/lib/postgresql/share/postgresql /usr/share/postgresql /var/lib/postgresql/data /var/run/postgresql && chown -R postgres:postgres /usr/lib/postgresql && chown -R postgres:postgres /var/lib/postgresql && chown -R postgres:postgres /usr/share/postgresql && chown -R postgres:postgres /var/run/postgresql # 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 # buildkit

RUN /bin/sh -c 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 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-stdout-log.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/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/bin/pgsodium_getkey.sh # 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/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit

COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.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|#include = '/etc/postgresql-custom/wal-g.conf'|include = '/etc/postgresql-custom/wal-g.conf'|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 # buildkit

RUN /bin/sh -c sed -i 's/ timescaledb,//g;' "/etc/postgresql/postgresql.conf" && sed -i 's/db_user_namespace = off/#db_user_namespace = off/g;' "/etc/postgresql/postgresql.conf" && sed -i 's/ timescaledb,//g; s/ plv8,//g; s/ postgis,//g; s/ pgrouting,//g' "/etc/postgresql-custom/supautils.conf" # buildkit

RUN /bin/sh -c sed -i 's/\(shared_preload_libraries.*\)'\''\(.*\)$/\1, orioledb'\''\2/' "/etc/postgresql/postgresql.conf" && echo "default_table_access_method = 'orioledb'" >> "/etc/postgresql/postgresql.conf" # 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

RUN /bin/sh -c echo "CREATE EXTENSION orioledb;" > /docker-entrypoint-initdb.d/init-scripts/00-pre-init.sql && chown postgres:postgres /docker-entrypoint-initdb.d/init-scripts/00-pre-init.sql # buildkit

ADD https://raw.githubusercontent.com/docker-library/postgres/6edb0a8c4def40c371514b34aef9037ec82d9110/17/alpine3.23/docker-entrypoint.sh /usr/local/bin/docker-entrypoint.sh # buildkit

RUN /bin/sh -c 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

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 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

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

ENTRYPOINT ["docker-entrypoint.sh"]

HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" "0s" '\n'}

STOPSIGNAL SIGINT

EXPOSE map[5432/tcp:{}]

CMD ["postgres" "-D" "/etc/postgresql"]