Namespace
supabase
Image / Tag
postgres:15.8.1.002
Content Digest
sha256:aee343ddecd8852370762900f27d0c24c3a4f4036648042a0f1ec96f2b174b4b
Details
Created

2024-10-02 03:23:44 UTC

Size

588 MB

Content Digest
Labels
  • org.opencontainers.image.ref.name
    ubuntu
  • org.opencontainers.image.version
    20.04

Environment
LANG

en_US.UTF-8

LANGUAGE

en_US:en

LC_ALL

en_US.UTF-8

LC_COLLATE

C.UTF-8

LC_CTYPE

C.UTF-8

LOCALE_ARCHIVE

/usr/lib/locale/locale-archive

PATH

/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/nix/var/nix/profiles/default/bin

PGDATA

/var/lib/postgresql/data

POSTGRES_DB

postgres

POSTGRES_HOST

/var/run/postgresql

POSTGRES_USER

supabase_admin


Layers

[#000] sha256:3823320faa42774534fd7eee0bd245af8cec6a720ad722144d40efa229291d8f - 4.46% (26.2 MB)

[#001] sha256:c32db10508446e7633078f0b39dca1fabaac44811e2b8ad28f91233f67eb938b - 14.14% (83.2 MB)

[#002] sha256:aa87b89788aeda360b88fa6d55c1b3bad3b34817b859a5ba0abff86be6ed22c4 - 0.0% (1.53 KB)

[#003] sha256:751cc0dbb6ff89cfa997510334e2c2c678ee8beba210dad53d3b29c7b1a28e13 - 0.0% (1.56 KB)

[#004] sha256:4b52ba6a40d11ca49f9ca4354aa03a423300ff278fd12fef596220ebc185ce02 - 11.73% (69 MB)

[#005] sha256:9818876e454c9a8de778e3c0bfcf47b243bf8150836619b7c853565750e6d228 - 0.06% (389 KB)

[#006] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#007] sha256:1a6aa78fa93bdd9b9cfc54afb613384a544e506499f71e0ceb8b2fcd6a8dbd2c - 49.45% (291 MB)

[#008] sha256:f0d382cb430ff8ce9b616884b7f668af73557272ccf44509c728693fb660dec6 - 0.0% (218 Bytes)

[#009] sha256:945845853696a7c41efbed5697c264bdfeeeadb0bf0871cc876973619e38af91 - 2.72% (16 MB)

[#010] sha256:b2298a2a8c3b029ca91740047a7004ab09fba3189f0d0a28e14e429c208053c1 - 0.0% (616 Bytes)

[#011] sha256:dc2be6412c9cde9de81bfeeef41c6e55b0b9e4c498056a046403a2b0458de651 - 0.0% (598 Bytes)

[#012] sha256:9e23db5dd7097d44591a91caca45bbfd3b7474a90995c3e64a31f5d361cdd876 - 0.0% (613 Bytes)

[#013] sha256:c834593a1b27054c716295b7a6e387d9cf4bd8fb4254931fe1ce5d462320bfda - 0.0% (595 Bytes)

[#014] sha256:62128f564465c0c3efbe62c2f3eb57e4a186a54c6b09a25074d493e2477e9ac8 - 0.13% (803 KB)

[#015] sha256:25b6df49f313337d18aee7f494c56e7ff120030ebac2ce9abaf5baa6d2ff50b8 - 0.0% (1.21 KB)

[#016] sha256:a9ce6b907ae24d64d798843cd159dc2e1eaaafc6cca704538addd5e335b3846d - 0.0% (291 Bytes)

[#017] sha256:64398ec0534e85822b9759cd65fc04b4760be309f08e9133cabf3c55a7bc2e77 - 0.0% (1.17 KB)

[#018] sha256:301d02946ceb8a51e1cac4d8f6ac84608f247300d36710f8975662c1642f61f6 - 0.07% (432 KB)

[#019] sha256:7bf212dfe9fbfda11804182b7c1ea4b938abb32cfa5ac60f829fdb0eaedb8ac4 - 13.48% (79.3 MB)

[#020] sha256:303f3a2157810e73b4706f3172e088de11867ec927892d53eac86f08ea39a963 - 0.0% (1.82 KB)

[#021] sha256:c45b36e4f413f1824f372655e7dfe5b84f7620d7f01d897359e1f0264b67e28a - 0.16% (960 KB)

[#022] sha256:d3784c151a2b6ad90a6185e947ef27192d397128bcff977ccd35b4ba3f849dbf - 0.0% (798 Bytes)

[#023] sha256:4844914396c997046416b3959ad1b844279c9bdb550f7f18b87a784f99f7460f - 0.16% (977 KB)

[#024] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#025] sha256:f49b66adefdda44219db33b68d0882e11c7c718062ee0db354b59d28ac020461 - 1.97% (11.6 MB)

[#026] sha256:e7f5fe6b79219a382a9d63a26484588245fbe4fd3166cf0793e393f383ea41ff - 0.0% (8.33 KB)

[#027] sha256:491814e97180543325260960f2374df3f0d003325b00a60a5ba24e85f9411a72 - 0.0% (1.85 KB)

[#028] sha256:c70291bc59026d01e633ca681eaa4e9fb0b03ea61050cba8254447c6771fab79 - 0.0% (1017 Bytes)

[#029] sha256:f7e6ca2f3115129aee461ea83da080edeafe50f3c5b6f83f3876066eaa501d1c - 0.0% (278 Bytes)

[#030] sha256:a69a685b83a24796e96d58f712d97f2eaf9d428e17ae8171976b30694345a05d - 0.0% (1.28 KB)

[#031] sha256:808cfca36edab47b169aab963ca8af0747b231e2b1e079a22b578ec0ba57f006 - 0.0% (1.9 KB)

[#032] sha256:16ba9ba99a0a6dbf8bb6cdf60e2e7193d8c33147ee87ed1671c91a36f3b120f7 - 0.0% (362 Bytes)

[#033] sha256:a870bfb0715582551a257a24150914134b78f339f6d2ae6583e2ef8cd520228b - 0.0% (334 Bytes)

[#034] sha256:d28ffbcda351ee44dc44e573f5e1591df5345c814cac9f3e34a251fc74f26bd6 - 0.0% (394 Bytes)

[#035] sha256:5245e6a2add08af051c9c15acc0e425350d019f2492f979c9dc5c90e60e38f17 - 0.0% (398 Bytes)

[#036] sha256:212630641b67970db88bffe3ce9f266173b729502034b88aa11b73eda9fc6ee2 - 0.0% (638 Bytes)

[#037] sha256:a4bf7f98dcf01792b2c668caa21059bb43b71c7b564e9081cd2e7885dc7acd0d - 0.0% (9.06 KB)

[#038] sha256:547346f6c108ae60c604fdacb0c5d9ae7cda752a5d587e2f7e112ff9a18479c1 - 0.0% (9.96 KB)

[#039] sha256:573dbb1fd44be8cef9c6bcd9939b601e30add07609ccd36c06cd08b7ba1869cb - 0.0% (509 Bytes)

[#040] sha256:29898267ff1a97fe1be915f93b141bc8189b29a9c84085f8f8a3a19224a7ea77 - 0.0% (272 Bytes)

[#041] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#042] sha256:f6b72eedd0311e91bc679468d18f46d239371cca69a4c381aa7b742078520844 - 0.0% (4.76 KB)

[#043] sha256:4a0d03b02614f2e9f4e9e4c4fdf4f7843a6629ac702f41bf917b2e229721f44a - 0.0% (128 Bytes)

[#044] sha256:e608f4895e14f4821d884da0e4c69621b335b1b023165c3ee18afbbe4a857314 - 1.21% (7.1 MB)

[#045] sha256:d5cb1333d0e000a7bb74473554bffb988fbeccea513a14d0f0f7099b203a49bd - 0.26% (1.5 MB)


History
2024-09-18 04:18:32 UTC

/bin/sh -c #(nop) ARG RELEASE

2024-09-18 04:18:32 UTC

/bin/sh -c #(nop) ARG LAUNCHPAD_BUILD_ARCH

2024-09-18 04:18:32 UTC

/bin/sh -c #(nop) LABEL org.opencontainers.image.ref.name=ubuntu

2024-09-18 04:18:32 UTC

/bin/sh -c #(nop) LABEL org.opencontainers.image.version=20.04

2024-09-18 04:18:34 UTC

/bin/sh -c #(nop) ADD file:6a209aa51ba684c0a39769619c42058ca99311b87563c7b079319a8bb91bec1f in /

2024-09-18 04:18:34 UTC

/bin/sh -c #(nop) CMD ["/bin/bash"]

2024-10-02 03:22:37 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt update -y && apt install -y curl gnupg lsb-release software-properties-common wget sudo && apt clean # buildkit

2024-10-02 03:22:43 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c adduser --system --home /var/lib/postgresql --no-create-home --shell /bin/bash --group --gecos "PostgreSQL administrator" postgres # buildkit

2024-10-02 03:22:43 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c adduser --system --no-create-home --shell /bin/bash --group wal-g # buildkit

2024-10-02 03:22:48 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c curl --proto '=https' --tlsv1.2 -sSf -L https://install.determinate.systems/nix | sh -s -- install linux --init none --no-confirm --extra-conf "substituters = https://cache.nixos.org https://nix-postgres-artifacts.s3.amazonaws.com" --extra-conf "trusted-public-keys = nix-postgres-artifacts:dGZlQOvKcNEjvT7QEAJbcV6b6uk7VF/hWMjhYleiaLI=% cache.nixos.org-1:6NCHdD59X431o0gWypbMrAURkbJ16ZPMQFGspcDShjY=" # buildkit

2024-10-02 03:22:49 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:22:49 UTC (buildkit.dockerfile.v0)

COPY . /nixpg # buildkit

2024-10-02 03:22:49 UTC (buildkit.dockerfile.v0)

WORKDIR /nixpg

2024-10-02 03:23:14 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c nix profile install .#psql_15/bin # buildkit

2024-10-02 03:23:14 UTC (buildkit.dockerfile.v0)

WORKDIR /

2024-10-02 03:23:15 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:16 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/bin/* /usr/lib/postgresql/bin/ && ln -s /nix/var/nix/profiles/default/bin/* /usr/bin/ && chown -R postgres:postgres /usr/bin # buildkit

2024-10-02 03:23:16 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ # buildkit

2024-10-02 03:23:16 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ # buildkit

2024-10-02 03:23:16 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:16 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:16 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /usr/lib/postgresql/share/postgresql/contrib && find /nix/var/nix/profiles/default/share/postgresql/contrib/ -mindepth 1 -type d -exec sh -c 'for dir do ln -s "$dir" "/usr/lib/postgresql/share/postgresql/contrib/$(basename "$dir")"; done' sh {} + && chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/contrib/ # buildkit

2024-10-02 03:23:16 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:17 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets # buildkit

2024-10-02 03:23:19 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends tzdata # buildkit

2024-10-02 03:23:19 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -fs /usr/share/zoneinfo/Etc/UTC /etc/localtime && dpkg-reconfigure --frontend noninteractive tzdata # buildkit

2024-10-02 03:23:31 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends build-essential checkinstall cmake # buildkit

2024-10-02 03:23:31 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2024-10-02 03:23:31 UTC (buildkit.dockerfile.v0)

ARG TARGETARCH

2024-10-02 03:23:34 UTC (buildkit.dockerfile.v0)

RUN |1 TARGETARCH=amd64 /bin/sh -c apt-get update && apt-get install -y --no-install-recommends gnupg ca-certificates && rm -rf /var/lib/apt/lists/* # buildkit

2024-10-02 03:23:34 UTC (buildkit.dockerfile.v0)

ARG GOSU_VERSION=1.16

2024-10-02 03:23:34 UTC (buildkit.dockerfile.v0)

ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4

2024-10-02 03:23:34 UTC (buildkit.dockerfile.v0)

ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64 /usr/local/bin/gosu # buildkit

2024-10-02 03:23:34 UTC (buildkit.dockerfile.v0)

ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64.asc /usr/local/bin/gosu.asc # buildkit

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

RUN |3 TARGETARCH=amd64 GOSU_VERSION=1.16 GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4 /bin/sh -c gpg --batch --keyserver hkps://keys.openpgp.org --recv-keys $GOSU_GPG_KEY && gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu && gpgconf --kill all && chmod +x /usr/local/bin/gosu # buildkit

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c id postgres || (echo "postgres user does not exist" && exit 1) # buildkit

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

COPY /tmp/wal-g /usr/local/bin/ # buildkit

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

COPY ansible/files/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit

2024-10-02 03:23:35 UTC (buildkit.dockerfile.v0)

COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.sh # buildkit

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

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 "cron.database_name = 'postgres'" >> /etc/postgresql/postgresql.conf && echo "pgsodium.getkey_script= '/usr/lib/postgresql/bin/pgsodium_getkey.sh'" >> /etc/postgresql/postgresql.conf && echo 'auto_explain.log_min_duration = 10s' >> /etc/postgresql/postgresql.conf && usermod -aG postgres wal-g && mkdir -p /etc/postgresql-custom && chown postgres:postgres /etc/postgresql-custom # buildkit

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

ADD https://github.com/docker-library/postgres/raw/master/15/bullseye/docker-entrypoint.sh /usr/local/bin/ # buildkit

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /var/run/postgresql && chown postgres:postgres /var/run/postgresql # buildkit

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_HOST=/var/run/postgresql

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_USER=supabase_admin

2024-10-02 03:23:36 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_DB=postgres

2024-10-02 03:23:42 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends locales && rm -rf /var/lib/apt/lists/* && localedef -i en_US -c -f UTF-8 -A /usr/share/locale/locale.alias en_US.UTF-8 && localedef -i C -c -f UTF-8 -A /usr/share/locale/locale.alias C.UTF-8 # buildkit

2024-10-02 03:23:44 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c echo "C.UTF-8 UTF-8" > /etc/locale.gen && echo "en_US.UTF-8 UTF-8" >> /etc/locale.gen && locale-gen # buildkit

2024-10-02 03:23:44 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.UTF-8

2024-10-02 03:23:44 UTC (buildkit.dockerfile.v0)

ENV LANGUAGE=en_US:en

2024-10-02 03:23:44 UTC (buildkit.dockerfile.v0)

ENV LC_ALL=en_US.UTF-8

2024-10-02 03:23:44 UTC (buildkit.dockerfile.v0)

ENV LC_CTYPE=C.UTF-8

2024-10-02 03:23:44 UTC (buildkit.dockerfile.v0)

ENV LC_COLLATE=C.UTF-8

2024-10-02 03:23:44 UTC (buildkit.dockerfile.v0)

ENV LOCALE_ARCHIVE=/usr/lib/locale/locale-archive

2024-10-02 03:23:44 UTC (buildkit.dockerfile.v0)

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

Details
Created

2024-10-02 03:27:14 UTC

Size

561 MB

Content Digest
Labels
  • org.opencontainers.image.ref.name
    ubuntu
  • org.opencontainers.image.version
    20.04

Environment
LANG

en_US.UTF-8

LANGUAGE

en_US:en

LC_ALL

en_US.UTF-8

LC_COLLATE

C.UTF-8

LC_CTYPE

C.UTF-8

LOCALE_ARCHIVE

/usr/lib/locale/locale-archive

PATH

/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/nix/var/nix/profiles/default/bin

PGDATA

/var/lib/postgresql/data

POSTGRES_DB

postgres

POSTGRES_HOST

/var/run/postgresql

POSTGRES_USER

supabase_admin


Layers

[#000] sha256:f7087ec3f63a82386ce40d74d075d761ece5bfaefdc30b9ef62f73ecfb2e41fe - 4.42% (24.8 MB)

[#001] sha256:4e963dbc31e50a69fe2b75ec124d0163fd052d1864419e9955c19b63af020eef - 12.78% (71.7 MB)

[#002] sha256:afac14c40a97b1f90b311af8b8d2d9fa2690a0e8e16abcfccc057fcf5eb81f52 - 0.0% (1.53 KB)

[#003] sha256:b1d773c3dc821c5aa9a32ebc23b96c1ea361e45fcdff7514a888ad50dd6432f1 - 0.0% (1.55 KB)

[#004] sha256:3e4eddd3607b5c47f4a50ce509d57a38f18d23c91da109c64241d10e742e6703 - 11.78% (66.1 MB)

[#005] sha256:2ac93e5c4954865c99b66a83685de5ca47cec068c3cb8ec4fe3b8a1a1b83fda1 - 0.07% (389 KB)

[#006] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#007] sha256:ae3b0d8eb27af34af95f93324f8ead06ad3aff005d3cef327b0654ff980724f2 - 51.14% (287 MB)

[#008] sha256:25f8371887ba84170b785e494df29483596bb8888e568906104f0dfe672f0dca - 0.0% (220 Bytes)

[#009] sha256:f5a11e0fafe6ddade5619360ba673d8fe12e42da3fe8a4edddaee870876e1eb4 - 2.83% (15.9 MB)

[#010] sha256:f342a48c00a05f29f0f048b22e6ed8aa50a6e8990718cf25ed95b09e45f2f856 - 0.0% (614 Bytes)

[#011] sha256:12250b7e21022ba1e28b8a07bfd8e6ef24a826b1a4041998c18a10abf425a5bd - 0.0% (595 Bytes)

[#012] sha256:58feb94a7b7d7d2e35c79550f07b6ec140372b26762dfb4c347985ffd2c9667f - 0.0% (611 Bytes)

[#013] sha256:127ca7913d85fcfe6637c404c6370401302a63d9236fb16f11adfa8f843f84fd - 0.0% (595 Bytes)

[#014] sha256:da2c31423cab0321f819937a44079ccd5093c38928a59a971368c6471e908bae - 0.14% (803 KB)

[#015] sha256:54c053d7ebcd6092a09c8df087375d449ce85b22cc4fcf94ee3d0068f60d243a - 0.0% (1.21 KB)

[#016] sha256:c5297811d0620e0ba4414708b5936cb322885aac64ce3d8d10ec7f7b620d3d2e - 0.0% (290 Bytes)

[#017] sha256:b818f4f3506fa63129f0c43302dfe81d2f57cf1445ec85bb2e5ca2670ef69723 - 0.0% (1.17 KB)

[#018] sha256:56107549f0c909989200f7e5582b24460a3cc3f56d6c05f4525d176857f40c65 - 0.08% (432 KB)

[#019] sha256:59f121cb2ef90883c74b3c8edc8725d84a924f987f41a2daa6a652a8852033c8 - 12.84% (72 MB)

[#020] sha256:cddce89ff7f3428ec87c5f62a9b5bd273f4015333c7b717ed6255d794ca47f9f - 0.0% (1.81 KB)

[#021] sha256:0840de5eae1b7066347d66e51221d69274adb3d724b21b7481aa206fb9a0d527 - 0.16% (892 KB)

[#022] sha256:6e0e9d4dec3a8f6e46a08b9e10e75e917be4d6f0bde53fa7da98008e9d8c1437 - 0.0% (793 Bytes)

[#023] sha256:3c4c0429680afcb3d159af7840a5a18e228eae6fa48fddf040086f77a542fc91 - 0.16% (909 KB)

[#024] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#025] sha256:af7923ec90a4d93c3f77957ceea9148f0d5450d423914d6a75ba47ef1b14bfa5 - 2.06% (11.6 MB)

[#026] sha256:d96bdb66babb6c1fec268c735f9597e4f6a70db7d6b43c0fed94347ae3250b07 - 0.0% (8.33 KB)

[#027] sha256:7776422c2052cbaae03c87cbc9698c8f554570587c56bf45c1046aa940c13b0c - 0.0% (1.85 KB)

[#028] sha256:ec4427fd3a626370ed3e0bde0aa12b03fa97cfcb3e6e7b35f5b854fe1a496ff0 - 0.0% (1017 Bytes)

[#029] sha256:3912a7ce42f6cc3b079b322de83ad79a911e8857b7d741746b8b38d260c8a80c - 0.0% (277 Bytes)

[#030] sha256:6e83a1b6d64e5947558d6242e7177b34abdbe26d556e571d9cafb547d647d744 - 0.0% (1.28 KB)

[#031] sha256:9e46f6b8639a2c232879ab868a2f6ad5bd36ac9fbe8dffb0a6419027490e7818 - 0.0% (1.9 KB)

[#032] sha256:64b114106a9b67512a506841d8f3517dc23a878f3079da37785d12341b659310 - 0.0% (364 Bytes)

[#033] sha256:3d06fc2286e7643016df0eee2efb0ff8552c20938ca76090d1be7aad46e39559 - 0.0% (335 Bytes)

[#034] sha256:5bbb18be01dc5466d88970b4e3991022e5fbd34e9362e68620647b5938f15d38 - 0.0% (394 Bytes)

[#035] sha256:6fbaf1e67bf70abc1bd053e283ef423aa9a883333508f596d4927ffac043e36e - 0.0% (397 Bytes)

[#036] sha256:2178fd18f9cdab21bf4fe317c0e98a0de69a0d0d34fa92e900e7f23e0c2ee11c - 0.0% (638 Bytes)

[#037] sha256:7a6d27f72a9cf919eb6269a7c93d96627c7b64ab62809844ad946799f99075dd - 0.0% (9.06 KB)

[#038] sha256:663ada24d56161b11f470c240c29fa4d024c850bb87976d3aa97ee4c2ce3ee82 - 0.0% (9.96 KB)

[#039] sha256:82b56091c4b43bf210bcb74d516a383b8556a9260cc149849afa0fbd425bd23b - 0.0% (507 Bytes)

[#040] sha256:43ebf50ad4a47cddd02973e44679b5e3b0ba240a28d8618a8b5dffdb53020935 - 0.0% (271 Bytes)

[#041] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#042] sha256:45444b1c9f69ab033e99bb4019d7c99755f43a80ce19f40a6ee4502364fc47d5 - 0.0% (4.76 KB)

[#043] sha256:b17329f32e10d6a0ec49f27f8d88c4481a336c41ac6011c1447da8a2fa86a72c - 0.0% (127 Bytes)

[#044] sha256:bafa9b85aeb97fd9fbb319955509269e82037138fe67f123765a9fb515d7d2bd - 1.27% (7.1 MB)

[#045] sha256:a47fc97647f09637c90ef3b2c44659cfa7150f7ace95119bfc35e82301e4f0db - 0.27% (1.5 MB)


History
2024-09-18 04:18:13 UTC

/bin/sh -c #(nop) ARG RELEASE

2024-09-18 04:18:13 UTC

/bin/sh -c #(nop) ARG LAUNCHPAD_BUILD_ARCH

2024-09-18 04:18:13 UTC

/bin/sh -c #(nop) LABEL org.opencontainers.image.ref.name=ubuntu

2024-09-18 04:18:13 UTC

/bin/sh -c #(nop) LABEL org.opencontainers.image.version=20.04

2024-09-18 04:18:15 UTC

/bin/sh -c #(nop) ADD file:193e44687e108da6ce3970dd4e85b4ab975e008873500871bb89e452afe82d52 in /

2024-09-18 04:18:15 UTC

/bin/sh -c #(nop) CMD ["/bin/bash"]

2024-10-02 03:25:54 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt update -y && apt install -y curl gnupg lsb-release software-properties-common wget sudo && apt clean # buildkit

2024-10-02 03:25:54 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c adduser --system --home /var/lib/postgresql --no-create-home --shell /bin/bash --group --gecos "PostgreSQL administrator" postgres # buildkit

2024-10-02 03:25:55 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c adduser --system --no-create-home --shell /bin/bash --group wal-g # buildkit

2024-10-02 03:26:00 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c curl --proto '=https' --tlsv1.2 -sSf -L https://install.determinate.systems/nix | sh -s -- install linux --init none --no-confirm --extra-conf "substituters = https://cache.nixos.org https://nix-postgres-artifacts.s3.amazonaws.com" --extra-conf "trusted-public-keys = nix-postgres-artifacts:dGZlQOvKcNEjvT7QEAJbcV6b6uk7VF/hWMjhYleiaLI=% cache.nixos.org-1:6NCHdD59X431o0gWypbMrAURkbJ16ZPMQFGspcDShjY=" # buildkit

2024-10-02 03:26:00 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:26:00 UTC (buildkit.dockerfile.v0)

COPY . /nixpg # buildkit

2024-10-02 03:26:00 UTC (buildkit.dockerfile.v0)

WORKDIR /nixpg

2024-10-02 03:26:37 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c nix profile install .#psql_15/bin # buildkit

2024-10-02 03:26:37 UTC (buildkit.dockerfile.v0)

WORKDIR /

2024-10-02 03:26:38 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:26:38 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/bin/* /usr/lib/postgresql/bin/ && ln -s /nix/var/nix/profiles/default/bin/* /usr/bin/ && chown -R postgres:postgres /usr/bin # buildkit

2024-10-02 03:26:38 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ # buildkit

2024-10-02 03:26:38 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ # buildkit

2024-10-02 03:26:38 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:26:39 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:26:39 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /usr/lib/postgresql/share/postgresql/contrib && find /nix/var/nix/profiles/default/share/postgresql/contrib/ -mindepth 1 -type d -exec sh -c 'for dir do ln -s "$dir" "/usr/lib/postgresql/share/postgresql/contrib/$(basename "$dir")"; done' sh {} + && chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/contrib/ # buildkit

2024-10-02 03:26:39 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:26:39 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets # buildkit

2024-10-02 03:26:42 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends tzdata # buildkit

2024-10-02 03:26:42 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -fs /usr/share/zoneinfo/Etc/UTC /etc/localtime && dpkg-reconfigure --frontend noninteractive tzdata # buildkit

2024-10-02 03:26:57 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends build-essential checkinstall cmake # buildkit

2024-10-02 03:26:57 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2024-10-02 03:26:57 UTC (buildkit.dockerfile.v0)

ARG TARGETARCH

2024-10-02 03:27:00 UTC (buildkit.dockerfile.v0)

RUN |1 TARGETARCH=arm64 /bin/sh -c apt-get update && apt-get install -y --no-install-recommends gnupg ca-certificates && rm -rf /var/lib/apt/lists/* # buildkit

2024-10-02 03:27:00 UTC (buildkit.dockerfile.v0)

ARG GOSU_VERSION=1.16

2024-10-02 03:27:00 UTC (buildkit.dockerfile.v0)

ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4

2024-10-02 03:27:00 UTC (buildkit.dockerfile.v0)

ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-arm64 /usr/local/bin/gosu # buildkit

2024-10-02 03:27:00 UTC (buildkit.dockerfile.v0)

ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-arm64.asc /usr/local/bin/gosu.asc # buildkit

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

RUN |3 TARGETARCH=arm64 GOSU_VERSION=1.16 GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4 /bin/sh -c gpg --batch --keyserver hkps://keys.openpgp.org --recv-keys $GOSU_GPG_KEY && gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu && gpgconf --kill all && chmod +x /usr/local/bin/gosu # buildkit

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c id postgres || (echo "postgres user does not exist" && exit 1) # buildkit

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

COPY /tmp/wal-g /usr/local/bin/ # buildkit

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

COPY ansible/files/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit

2024-10-02 03:27:01 UTC (buildkit.dockerfile.v0)

COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.sh # buildkit

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

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 "cron.database_name = 'postgres'" >> /etc/postgresql/postgresql.conf && echo "pgsodium.getkey_script= '/usr/lib/postgresql/bin/pgsodium_getkey.sh'" >> /etc/postgresql/postgresql.conf && echo 'auto_explain.log_min_duration = 10s' >> /etc/postgresql/postgresql.conf && usermod -aG postgres wal-g && mkdir -p /etc/postgresql-custom && chown postgres:postgres /etc/postgresql-custom # buildkit

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

ADD https://github.com/docker-library/postgres/raw/master/15/bullseye/docker-entrypoint.sh /usr/local/bin/ # buildkit

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /var/run/postgresql && chown postgres:postgres /var/run/postgresql # buildkit

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

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

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_HOST=/var/run/postgresql

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_USER=supabase_admin

2024-10-02 03:27:02 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_DB=postgres

2024-10-02 03:27:11 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends locales && rm -rf /var/lib/apt/lists/* && localedef -i en_US -c -f UTF-8 -A /usr/share/locale/locale.alias en_US.UTF-8 && localedef -i C -c -f UTF-8 -A /usr/share/locale/locale.alias C.UTF-8 # buildkit

2024-10-02 03:27:14 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c echo "C.UTF-8 UTF-8" > /etc/locale.gen && echo "en_US.UTF-8 UTF-8" >> /etc/locale.gen && locale-gen # buildkit

2024-10-02 03:27:14 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.UTF-8

2024-10-02 03:27:14 UTC (buildkit.dockerfile.v0)

ENV LANGUAGE=en_US:en

2024-10-02 03:27:14 UTC (buildkit.dockerfile.v0)

ENV LC_ALL=en_US.UTF-8

2024-10-02 03:27:14 UTC (buildkit.dockerfile.v0)

ENV LC_CTYPE=C.UTF-8

2024-10-02 03:27:14 UTC (buildkit.dockerfile.v0)

ENV LC_COLLATE=C.UTF-8

2024-10-02 03:27:14 UTC (buildkit.dockerfile.v0)

ENV LOCALE_ARCHIVE=/usr/lib/locale/locale-archive

2024-10-02 03:27:14 UTC (buildkit.dockerfile.v0)

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

Danger Zone
Delete Tag

Please be careful as this will not just delete the reference but also the actual content!

For example when you have latest and v1.2.3 both pointing to the same image
the deletion of latest will also permanently remove v1.2.3.

Delete