Namespace
dataease
Image / Tagsqlbot:v1.4.0
Content Digestsha256:450bce5147b586076f5f6a539bdeb587dcd4326ba9a2e2ccaf430c4f2523745e
Details
2025-12-04 03:20:24 UTC
1.81 GB
Environment
DB_CLIENT/opt/sqlbot/db_client
DM_HOME/opt/dmdbms
GOSU_VERSION1.17
LANGen_US.utf8
LD_LIBRARY_PATH/opt/dmdbms/bin:/opt/sqlbot/db_client/oracle_instant_client:
PATH/opt/sqlbot/app/.venv/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR17
PG_VERSION17.6-1.pgdg12+1
POSTGRES_DBsqlbot
POSTGRES_PASSWORDPassword123@pg
POSTGRES_USERroot
PYTHONPATH/opt/sqlbot/app
PYTHONUNBUFFERED1
SQLBOT_HOME/opt/sqlbot
Layers
[#000] sha256:af7c915c88494a197ce5f1ef0b0e7ca86bdd56a613a975f75d2c6dd9511922c7 - 1.5% (27.8 MB)
[#001] sha256:3166755df2cd1988f231f0033260fc94747f5435503225060769ea4ec3b06f07 - 0.0% (1.14 KB)
[#002] sha256:93c86b7657ed1289b28d79ebbab053d2c8abf7a3e5b27f446a33fcb81311cb0a - 0.23% (4.32 MB)
[#003] sha256:c1499316ffcfa748a10deee3ed7645645a01bc372a8fe9b9bd14e1cd0df5c464 - 0.07% (1.38 MB)
[#004] sha256:6e6162b82c961596fd81c96b0d027c6977b04856b344d4c6b37036fd25804592 - 0.41% (7.69 MB)
[#005] sha256:678fdefd6cc39131fa99ef3e532be8627d17e1b39a17b32b375c23584095d9be - 0.06% (1.14 MB)
[#006] sha256:7960bd43e7e7093fc87228eaf9f132681666766f6fada680c0a498256ce300c7 - 0.0% (116 Bytes)
[#007] sha256:1eef446a2d115c56650f364dc950fc80e4338b8141a9ac82ed6fdc1a34a7adca - 0.0% (3.07 KB)
[#008] sha256:717379dd4557593dd073a1d33e202a9b43a51fa7497284b3ad6f481345113536 - 5.79% (108 MB)
[#009] sha256:1752a03d130bcffe8bf13c8808188e4eec0512031f3e9b4c6c3539263b422eac - 0.0% (10 KB)
[#010] sha256:ee33dce80c14236f03e5972d44d90b4eaf7908ab8f2b9bda4c45eb07ee6e32f6 - 0.0% (128 Bytes)
[#011] sha256:5332a007b18549726e1810f819ac509c86ed00c15f26e7eb6efeeb94611dfb2b - 0.0% (168 Bytes)
[#012] sha256:5a24baf7c78c8697fcee99bcca4a2842ae8093ca8a49c1e2d34e87153a21bd1a - 0.0% (5.79 KB)
[#013] sha256:55772d575d05d04f07bf82489f789c98621f643e5c5f8a49e94588780d69cf5f - 0.0% (186 Bytes)
[#014] sha256:d16299ff3f87ff575cc6869657c06c344343b2941738c73387c21b28e0d45908 - 0.01% (119 KB)
[#015] sha256:2b715279f55e071fc7c3c5d7b117ce1d087cf17260416a43887b030f5c9b8036 - 0.07% (1.38 MB)
[#016] sha256:096853695051e48ba7dce1d712758e0256ef5b285bf3f8f14bf5363d8c655440 - 0.69% (12.8 MB)
[#017] sha256:070a832b6adff23d539d9bab98f0d122ab3ba671263bf50299ea96ed16bdbdcf - 0.16% (3 MB)
[#018] sha256:cb61b47811a7d31dd8ffa390c699a768ce518aa70cc1d19728f7aa7382e422bd - 0.89% (16.6 MB)
[#019] sha256:6da66ccebba6dbad21b8306e5a50c24693720eebdea209fbe16af022406b61cc - 9.73% (181 MB)
[#020] sha256:cc97c5fee81fc88f2c973d6716476e7e8f7a2744c900cfd2cb776221389bbab3 - 7.12% (132 MB)
[#021] sha256:a574f928fe11ea1b96f515f28ffd260de9de881313ba271ef571d6e0ce40a4b0 - 0.09% (1.71 MB)
[#022] sha256:346808b997eb2a4b6c3338115ad8582da22c50ef2a300e1c4cad500305c843d9 - 0.0% (192 Bytes)
[#023] sha256:3a613f9bd5043c91ce6ba4c893a1823d562a0c102419dc2ceb9b988a2f8a3919 - 0.0% (450 Bytes)
[#024] sha256:84a35bde98f1aef0f1a32da228e7b4a0681b568b1a0ef5d93381506258f9f295 - 0.79% (14.6 MB)
[#025] sha256:202511046cad1ada51e64665c10a87f3dd04c5e715251cd223c7ec213853d281 - 29.77% (553 MB)
[#026] sha256:b2c6e1507b04b9b45b5f7fc89d79caaad85c54e5fd3605a500de74360f8c0ade - 3.47% (64.5 MB)
[#027] sha256:2107cc6e6a9813461a47af9e5c2fb825865691e4c0255d9db681bb362b9d14ba - 39.13% (727 MB)
[#028] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#029] sha256:b57e6f12769406e6cb9c9755ffd0a4ae3a8c0bd43031db22663a290057564270 - 0.0% (140 Bytes)
History
# debian.sh --arch 'amd64' out/ 'bookworm' '@1754870400'
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -eux; groupadd -r postgres --gid=999; useradd -r -g postgres --uid=999 --home-dir=/var/lib/postgresql --shell=/bin/bash postgres; install --verbose --directory --owner postgres --group postgres --mode 1777 /var/lib/postgresql # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -ex; apt-get update; apt-get install -y --no-install-recommends gnupg less ; rm -rf /var/lib/apt/lists/* # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV GOSU_VERSION=1.17
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -eux; savedAptMark="$(apt-mark showmanual)"; apt-get update; apt-get install -y --no-install-recommends ca-certificates wget; rm -rf /var/lib/apt/lists/*; dpkgArch="$(dpkg --print-architecture | awk -F- '{ print $NF }')"; wget -O /usr/local/bin/gosu "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch"; wget -O /usr/local/bin/gosu.asc "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch.asc"; export GNUPGHOME="$(mktemp -d)"; gpg --batch --keyserver hkps://keys.openpgp.org --recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4; gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu; gpgconf --kill all; rm -rf "$GNUPGHOME" /usr/local/bin/gosu.asc; apt-mark auto '.*' > /dev/null; [ -z "$savedAptMark" ] || apt-mark manual $savedAptMark > /dev/null; apt-get purge -y --auto-remove -o APT::AutoRemove::RecommendsImportant=false; chmod +x /usr/local/bin/gosu; gosu --version; gosu nobody true # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -eux; if [ -f /etc/dpkg/dpkg.cfg.d/docker ]; then grep -q '/usr/share/locale' /etc/dpkg/dpkg.cfg.d/docker; sed -ri '/\/usr\/share\/locale/d' /etc/dpkg/dpkg.cfg.d/docker; ! grep -q '/usr/share/locale' /etc/dpkg/dpkg.cfg.d/docker; fi; apt-get update; apt-get install -y --no-install-recommends locales; rm -rf /var/lib/apt/lists/*; echo 'en_US.UTF-8 UTF-8' >> /etc/locale.gen; locale-gen; locale -a | grep 'en_US.utf8' # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.utf8
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -eux; apt-get update; apt-get install -y --no-install-recommends libnss-wrapper xz-utils zstd ; rm -rf /var/lib/apt/lists/* # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -ex; key='B97B0AFCAA1A47F044F244A07FCC7D46ACCC4CF8'; export GNUPGHOME="$(mktemp -d)"; mkdir -p /usr/local/share/keyrings/; gpg --batch --keyserver keyserver.ubuntu.com --recv-keys "$key"; gpg --batch --export --armor "$key" > /usr/local/share/keyrings/postgres.gpg.asc; gpgconf --kill all; rm -rf "$GNUPGHOME" # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV PG_MAJOR=17
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=17.6-1.pgdg12+1
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -ex; export PYTHONDONTWRITEBYTECODE=1; dpkgArch="$(dpkg --print-architecture)"; aptRepo="[ signed-by=/usr/local/share/keyrings/postgres.gpg.asc ] http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main $PG_MAJOR"; case "$dpkgArch" in amd64 | arm64 | ppc64el) echo "deb $aptRepo" > /etc/apt/sources.list.d/pgdg.list; apt-get update; ;; *) echo "deb-src $aptRepo" > /etc/apt/sources.list.d/pgdg.list; savedAptMark="$(apt-mark showmanual)"; tempDir="$(mktemp -d)"; cd "$tempDir"; apt-get update; apt-get install -y --no-install-recommends dpkg-dev; echo "deb [ trusted=yes ] file://$tempDir ./" > /etc/apt/sources.list.d/temp.list; _update_repo() { dpkg-scanpackages . > Packages; apt-get -o Acquire::GzipIndexes=false update; }; _update_repo; nproc="$(nproc)"; export DEB_BUILD_OPTIONS="nocheck parallel=$nproc"; apt-get build-dep -y postgresql-common-dev; apt-get source --compile postgresql-common-dev; _update_repo; apt-get build-dep -y "postgresql-$PG_MAJOR=$PG_VERSION"; apt-get source --compile "postgresql-$PG_MAJOR=$PG_VERSION"; apt-mark showmanual | xargs apt-mark auto > /dev/null; apt-mark manual $savedAptMark; ls -lAFh; _update_repo; grep '^Package: ' Packages; cd /; ;; esac; apt-get install -y --no-install-recommends postgresql-common; sed -ri 's/#(create_main_cluster) .*$/\1 = false/' /etc/postgresql-common/createcluster.conf; apt-get install -y --no-install-recommends "postgresql-$PG_MAJOR=$PG_VERSION" ; rm -rf /var/lib/apt/lists/*; if [ -n "$tempDir" ]; then apt-get purge -y --auto-remove; rm -rf "$tempDir" /etc/apt/sources.list.d/temp.list; fi; find /usr -name '*.pyc' -type f -exec bash -c 'for pyc; do dpkg -S "$pyc" &> /dev/null || rm -vf "$pyc"; done' -- '{}' +; postgres --version # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -eux; dpkg-divert --add --rename --divert "/usr/share/postgresql/postgresql.conf.sample.dpkg" "/usr/share/postgresql/$PG_MAJOR/postgresql.conf.sample"; cp -v /usr/share/postgresql/postgresql.conf.sample.dpkg /usr/share/postgresql/postgresql.conf.sample; ln -sv ../postgresql.conf.sample "/usr/share/postgresql/$PG_MAJOR/"; sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/share/postgresql/postgresql.conf.sample; grep -F "listen_addresses = '*'" /usr/share/postgresql/postgresql.conf.sample # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c install --verbose --directory --owner postgres --group postgres --mode 3777 /var/run/postgresql # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c install --verbose --directory --owner postgres --group postgres --mode 1777 "$PGDATA" # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)VOLUME [/var/lib/postgresql/data]
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)COPY docker-entrypoint.sh docker-ensure-initdb.sh /usr/local/bin/ # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sT docker-ensure-initdb.sh /usr/local/bin/docker-enforce-initdb.sh # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)CMD ["postgres"]
2025-08-15 18:24:14 UTC (buildkit.dockerfile.v0)ARG PG_MAJOR=17
2025-08-15 18:24:14 UTC (buildkit.dockerfile.v0)ADD https://github.com/pgvector/pgvector.git#v0.8.0 /tmp/pgvector # buildkit
2025-08-15 18:25:22 UTC (buildkit.dockerfile.v0)RUN |1 PG_MAJOR=17 /bin/sh -c apt-get update && apt-mark hold locales && apt-get install -y --no-install-recommends build-essential postgresql-server-dev-$PG_MAJOR && cd /tmp/pgvector && make clean && make OPTFLAGS="" && make install && mkdir /usr/share/doc/pgvector && cp LICENSE README.md /usr/share/doc/pgvector && rm -r /tmp/pgvector && apt-get remove -y build-essential postgresql-server-dev-$PG_MAJOR && apt-get autoremove -y && apt-mark unhold locales && rm -rf /var/lib/apt/lists/* # buildkit
2025-12-03 14:09:01 UTC (buildkit.dockerfile.v0)COPY /usr/local /usr/local # buildkit
2025-12-03 14:09:02 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c python --version && pip --version # buildkit
2025-12-03 14:09:02 UTC (buildkit.dockerfile.v0)COPY /uv /uvx /bin/ # buildkit
2025-12-03 14:09:40 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends wait-for-it build-essential curl gnupg gcc g++ libcairo2-dev libpango1.0-dev libjpeg-dev libgif-dev librsvg2-dev && curl -fsSL https://deb.nodesource.com/setup_18.x | bash - && curl -qL https://www.npmjs.com/install.sh | sh - && apt-get install -y nodejs && curl -L --connect-timeout 60 -m 1800 https://fit2cloud-support.oss-cn-beijing.aliyuncs.com/xpack-license/get-validator-linux | sh && rm -rf /var/lib/apt/lists/* && chmod g+xr /usr/bin/ld.so && chmod g+x /usr/local/bin/python* # buildkit
2025-12-03 14:09:47 UTC (buildkit.dockerfile.v0)ENV DB_CLIENT=/opt/sqlbot/db_client
2025-12-03 14:09:47 UTC (buildkit.dockerfile.v0)ENV LD_LIBRARY_PATH=/opt/sqlbot/db_client/oracle_instant_client:
2025-12-03 14:09:47 UTC (buildkit.dockerfile.v0)ARG TARGETARCH=amd64
2025-12-03 14:09:47 UTC (buildkit.dockerfile.v0)RUN |1 TARGETARCH=amd64 /bin/sh -c apt-get update && apt-get install -y unzip libaio1 && mkdir -p ${DB_CLIENT} && if [ "$TARGETARCH" = "amd64" ]; then echo "Building for x86_64"; curl -L -o app.zip https://download.oracle.com/otn_software/linux/instantclient/2326000/instantclient-basic-linux.x64-23.26.0.0.0.zip; elif [ "$TARGETARCH" = "arm64" ]; then echo "Building for ARM64"; curl -L -o app.zip https://download.oracle.com/otn_software/linux/instantclient/2390000/instantclient-basic-linux.arm64-23.9.0.25.07.zip; fi && unzip app.zip -d ${DB_CLIENT} && rm app.zip && rm -rf /var/lib/apt/lists/* && mv ${DB_CLIENT}/instantclient* ${DB_CLIENT}/oracle_instant_client # buildkit
2025-12-03 14:09:47 UTC (buildkit.dockerfile.v0)ENV DM_HOME=/opt/dmdbms
2025-12-03 14:09:47 UTC (buildkit.dockerfile.v0)ENV LD_LIBRARY_PATH=/opt/dmdbms/bin:/opt/sqlbot/db_client/oracle_instant_client:
2025-12-03 14:09:50 UTC (buildkit.dockerfile.v0)RUN |1 TARGETARCH=amd64 /bin/sh -c curl -L -o dm.zip https://resource-fit2cloud-com.oss-cn-hangzhou.aliyuncs.com/sqlbot/dm/$TARGETARCH.zip && mkdir -p $DM_HOME/bin && unzip dm.zip -d $DM_HOME/bin && chmod -R +x $DM_HOME/bin && rm -rf dm.zip # buildkit
2025-12-04 03:14:28 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime && echo "Asia/Shanghai" > /etc/timezone # buildkit
2025-12-04 03:14:28 UTC (buildkit.dockerfile.v0)ENV PYTHONUNBUFFERED=1
2025-12-04 03:14:28 UTC (buildkit.dockerfile.v0)ENV SQLBOT_HOME=/opt/sqlbot
2025-12-04 03:14:28 UTC (buildkit.dockerfile.v0)ENV PYTHONPATH=/opt/sqlbot/app
2025-12-04 03:14:28 UTC (buildkit.dockerfile.v0)ENV PATH=/opt/sqlbot/app/.venv/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin
2025-12-04 03:14:28 UTC (buildkit.dockerfile.v0)ENV POSTGRES_DB=sqlbot
2025-12-04 03:14:28 UTC (buildkit.dockerfile.v0)ENV POSTGRES_USER=root
2025-12-04 03:14:28 UTC (buildkit.dockerfile.v0)ENV POSTGRES_PASSWORD=Password123@pg
2025-12-04 03:14:28 UTC (buildkit.dockerfile.v0)COPY start.sh /opt/sqlbot/app/start.sh # buildkit
2025-12-04 03:14:28 UTC (buildkit.dockerfile.v0)COPY g2-ssr/*.ttf /usr/share/fonts/truetype/liberation/ # buildkit
2025-12-04 03:20:09 UTC (buildkit.dockerfile.v0)COPY /opt/sqlbot /opt/sqlbot # buildkit
2025-12-04 03:20:19 UTC (buildkit.dockerfile.v0)COPY /app /opt/sqlbot/g2-ssr # buildkit
2025-12-04 03:20:24 UTC (buildkit.dockerfile.v0)COPY /opt/maxkb/app/model /opt/sqlbot/models # buildkit
2025-12-04 03:20:24 UTC (buildkit.dockerfile.v0)WORKDIR /opt/sqlbot/app
2025-12-04 03:20:24 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /opt/sqlbot/images /opt/sqlbot/g2-ssr # buildkit
2025-12-04 03:20:24 UTC (buildkit.dockerfile.v0)EXPOSE [3000/tcp 5432/tcp 8000/tcp 8001/tcp]
2025-12-04 03:20:24 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "curl -f http://localhost:8000 || exit 1"] "30s" "10s" "5s" "0s" '\x03'}
2025-12-04 03:20:24 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["sh" "start.sh"]
Details
2025-12-04 03:26:59 UTC
1.67 GB
Environment
DB_CLIENT/opt/sqlbot/db_client
DM_HOME/opt/dmdbms
GOSU_VERSION1.17
LANGen_US.utf8
LD_LIBRARY_PATH/opt/dmdbms/bin:/opt/sqlbot/db_client/oracle_instant_client:
PATH/opt/sqlbot/app/.venv/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR17
PG_VERSION17.6-1.pgdg12+1
POSTGRES_DBsqlbot
POSTGRES_PASSWORDPassword123@pg
POSTGRES_USERroot
PYTHONPATH/opt/sqlbot/app
PYTHONUNBUFFERED1
SQLBOT_HOME/opt/sqlbot
Layers
[#000] sha256:2a1d1e47d5d3882516b73175b002f18275a8043fe435e97fb8230e445ebe0aee - 1.63% (27.8 MB)
[#001] sha256:6f22bf4a69c67725a5d28659467a9f4119ed414adf8a1d433e11ad80206e7a29 - 0.0% (1.14 KB)
[#002] sha256:361ee65475462ea3e8ee78a207e0ee11b503288d0fc59ca7e79ac316ec6acc04 - 0.25% (4.29 MB)
[#003] sha256:d686f5a8767e8f7119f4019c78e95b41922a788f6adf346700ad86916e3f0d47 - 0.08% (1.31 MB)
[#004] sha256:e8c4da94471816abaff082b723798940778c0d6e9ba39ca35822ae23757628b1 - 0.45% (7.69 MB)
[#005] sha256:30dd948fe7b916f24497e0aa4ac3ea5f654f2ec18fecaf144b35e44757fcc0f5 - 0.06% (1.06 MB)
[#006] sha256:0c9e7f843ae66f3ff0fb7f0e9b43b16750e2dff4f3d8bb23e783ba6c4e9faa04 - 0.0% (116 Bytes)
[#007] sha256:3bb81ba96e939b60e2849bd3e78c77085a5b656b0da6722c19eec786712cb1a7 - 0.0% (3.07 KB)
[#008] sha256:dd7b64205bd3a8c57e5c34d5246ef6e204f453dee3fd18f61b81b1586a313bb9 - 6.19% (106 MB)
[#009] sha256:3d32ea573bdb873df1d9acae8df59a14ddea54cc5a663c89e89afec2b8a16fe7 - 0.0% (10 KB)
[#010] sha256:accd77805fbec74ad682a6101df7bf2f01da35332015b45cb5284d10e197d8c3 - 0.0% (128 Bytes)
[#011] sha256:e891ae7f1c9547369ce5f01929bd01c832e981c3dd062893134d25e7daa9c1a9 - 0.0% (166 Bytes)
[#012] sha256:aa5f13dc1dd6ac3db6ff8ccf696f5a8e439d5252ead4b2ca6182fcae9035c936 - 0.0% (5.79 KB)
[#013] sha256:89f0daa30241ecec55d072ee50f4916c452eb8cc66774b0f73e9a0139e7dfbb3 - 0.0% (185 Bytes)
[#014] sha256:d16299ff3f87ff575cc6869657c06c344343b2941738c73387c21b28e0d45908 - 0.01% (119 KB)
[#015] sha256:74d908e27d8da95260aff1ecd76e7b129a8e5a3700954d409ac936fa1b8f05f4 - 0.08% (1.31 MB)
[#016] sha256:7724f910506012e1e6fd60439df586ad44fc72d85f22c08d0aacdef131008805 - 0.74% (12.7 MB)
[#017] sha256:1f4204f2124a0c958705e819efddd87eca8b71844ffcc94f1c3e598b1001460d - 0.18% (3 MB)
[#018] sha256:5b825a103c6d6fb184322cd2e633b559b8f22a4c300da0ce99f4c1703c26a28a - 0.92% (15.7 MB)
[#019] sha256:007d400fbaa2520ff1c4c96a43e992023ded73775271dbff485d854f74852db9 - 10.17% (174 MB)
[#020] sha256:003ef46db4c44f8c929c112068d9cf97c38abe6518a52200733138953dc3647b - 7.19% (123 MB)
[#021] sha256:dd4b9af4f62109ab1b8399020f524a687055480485b5aee3cf040ba14abf92f3 - 0.1% (1.65 MB)
[#022] sha256:a2a1c6d35022e11eab36d4e2bd60445f1c345ce14130adb4fc50cc05820163f8 - 0.0% (193 Bytes)
[#023] sha256:ba15d2b5431c8eadd0eec6d7c67e883d8b29c8ea69989405127559ae229bceaf - 0.0% (449 Bytes)
[#024] sha256:877faf67bc8404cf1734fd1fb0e843c3b6b9bba213b328565ca0e23958a841d6 - 0.85% (14.6 MB)
[#025] sha256:e723640e73a4125050f1898f2c979e770bf06b4f074d34f139c3fb56fcc087b8 - 27.61% (473 MB)
[#026] sha256:113ba8d4dace0cafa5e61470b70ee055322895de1d038f6cfd4afedc669bd626 - 1.04% (17.8 MB)
[#027] sha256:85ae432b678614a172048e3119f52860d0c6fa383b91c9370928fe3e14299ad2 - 42.47% (727 MB)
[#028] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#029] sha256:966902ed69fc295d66f3c8fbaa4345299e0be03aa2a833be3ada8dbbb4f36dd3 - 0.0% (141 Bytes)
History
# debian.sh --arch 'arm64' out/ 'bookworm' '@1754870400'
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -eux; groupadd -r postgres --gid=999; useradd -r -g postgres --uid=999 --home-dir=/var/lib/postgresql --shell=/bin/bash postgres; install --verbose --directory --owner postgres --group postgres --mode 1777 /var/lib/postgresql # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -ex; apt-get update; apt-get install -y --no-install-recommends gnupg less ; rm -rf /var/lib/apt/lists/* # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV GOSU_VERSION=1.17
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -eux; savedAptMark="$(apt-mark showmanual)"; apt-get update; apt-get install -y --no-install-recommends ca-certificates wget; rm -rf /var/lib/apt/lists/*; dpkgArch="$(dpkg --print-architecture | awk -F- '{ print $NF }')"; wget -O /usr/local/bin/gosu "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch"; wget -O /usr/local/bin/gosu.asc "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch.asc"; export GNUPGHOME="$(mktemp -d)"; gpg --batch --keyserver hkps://keys.openpgp.org --recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4; gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu; gpgconf --kill all; rm -rf "$GNUPGHOME" /usr/local/bin/gosu.asc; apt-mark auto '.*' > /dev/null; [ -z "$savedAptMark" ] || apt-mark manual $savedAptMark > /dev/null; apt-get purge -y --auto-remove -o APT::AutoRemove::RecommendsImportant=false; chmod +x /usr/local/bin/gosu; gosu --version; gosu nobody true # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -eux; if [ -f /etc/dpkg/dpkg.cfg.d/docker ]; then grep -q '/usr/share/locale' /etc/dpkg/dpkg.cfg.d/docker; sed -ri '/\/usr\/share\/locale/d' /etc/dpkg/dpkg.cfg.d/docker; ! grep -q '/usr/share/locale' /etc/dpkg/dpkg.cfg.d/docker; fi; apt-get update; apt-get install -y --no-install-recommends locales; rm -rf /var/lib/apt/lists/*; echo 'en_US.UTF-8 UTF-8' >> /etc/locale.gen; locale-gen; locale -a | grep 'en_US.utf8' # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.utf8
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -eux; apt-get update; apt-get install -y --no-install-recommends libnss-wrapper xz-utils zstd ; rm -rf /var/lib/apt/lists/* # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -ex; key='B97B0AFCAA1A47F044F244A07FCC7D46ACCC4CF8'; export GNUPGHOME="$(mktemp -d)"; mkdir -p /usr/local/share/keyrings/; gpg --batch --keyserver keyserver.ubuntu.com --recv-keys "$key"; gpg --batch --export --armor "$key" > /usr/local/share/keyrings/postgres.gpg.asc; gpgconf --kill all; rm -rf "$GNUPGHOME" # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV PG_MAJOR=17
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=17.6-1.pgdg12+1
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -ex; export PYTHONDONTWRITEBYTECODE=1; dpkgArch="$(dpkg --print-architecture)"; aptRepo="[ signed-by=/usr/local/share/keyrings/postgres.gpg.asc ] http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main $PG_MAJOR"; case "$dpkgArch" in amd64 | arm64 | ppc64el) echo "deb $aptRepo" > /etc/apt/sources.list.d/pgdg.list; apt-get update; ;; *) echo "deb-src $aptRepo" > /etc/apt/sources.list.d/pgdg.list; savedAptMark="$(apt-mark showmanual)"; tempDir="$(mktemp -d)"; cd "$tempDir"; apt-get update; apt-get install -y --no-install-recommends dpkg-dev; echo "deb [ trusted=yes ] file://$tempDir ./" > /etc/apt/sources.list.d/temp.list; _update_repo() { dpkg-scanpackages . > Packages; apt-get -o Acquire::GzipIndexes=false update; }; _update_repo; nproc="$(nproc)"; export DEB_BUILD_OPTIONS="nocheck parallel=$nproc"; apt-get build-dep -y postgresql-common-dev; apt-get source --compile postgresql-common-dev; _update_repo; apt-get build-dep -y "postgresql-$PG_MAJOR=$PG_VERSION"; apt-get source --compile "postgresql-$PG_MAJOR=$PG_VERSION"; apt-mark showmanual | xargs apt-mark auto > /dev/null; apt-mark manual $savedAptMark; ls -lAFh; _update_repo; grep '^Package: ' Packages; cd /; ;; esac; apt-get install -y --no-install-recommends postgresql-common; sed -ri 's/#(create_main_cluster) .*$/\1 = false/' /etc/postgresql-common/createcluster.conf; apt-get install -y --no-install-recommends "postgresql-$PG_MAJOR=$PG_VERSION" ; rm -rf /var/lib/apt/lists/*; if [ -n "$tempDir" ]; then apt-get purge -y --auto-remove; rm -rf "$tempDir" /etc/apt/sources.list.d/temp.list; fi; find /usr -name '*.pyc' -type f -exec bash -c 'for pyc; do dpkg -S "$pyc" &> /dev/null || rm -vf "$pyc"; done' -- '{}' +; postgres --version # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -eux; dpkg-divert --add --rename --divert "/usr/share/postgresql/postgresql.conf.sample.dpkg" "/usr/share/postgresql/$PG_MAJOR/postgresql.conf.sample"; cp -v /usr/share/postgresql/postgresql.conf.sample.dpkg /usr/share/postgresql/postgresql.conf.sample; ln -sv ../postgresql.conf.sample "/usr/share/postgresql/$PG_MAJOR/"; sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/share/postgresql/postgresql.conf.sample; grep -F "listen_addresses = '*'" /usr/share/postgresql/postgresql.conf.sample # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c install --verbose --directory --owner postgres --group postgres --mode 3777 /var/run/postgresql # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c install --verbose --directory --owner postgres --group postgres --mode 1777 "$PGDATA" # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)VOLUME [/var/lib/postgresql/data]
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)COPY docker-entrypoint.sh docker-ensure-initdb.sh /usr/local/bin/ # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sT docker-ensure-initdb.sh /usr/local/bin/docker-enforce-initdb.sh # buildkit
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2025-08-14 17:12:46 UTC (buildkit.dockerfile.v0)CMD ["postgres"]
2025-08-15 18:24:14 UTC (buildkit.dockerfile.v0)ARG PG_MAJOR=17
2025-08-15 18:24:14 UTC (buildkit.dockerfile.v0)ADD https://github.com/pgvector/pgvector.git#v0.8.0 /tmp/pgvector # buildkit
2025-08-15 18:24:35 UTC (buildkit.dockerfile.v0)RUN |1 PG_MAJOR=17 /bin/sh -c apt-get update && apt-mark hold locales && apt-get install -y --no-install-recommends build-essential postgresql-server-dev-$PG_MAJOR && cd /tmp/pgvector && make clean && make OPTFLAGS="" && make install && mkdir /usr/share/doc/pgvector && cp LICENSE README.md /usr/share/doc/pgvector && rm -r /tmp/pgvector && apt-get remove -y build-essential postgresql-server-dev-$PG_MAJOR && apt-get autoremove -y && apt-mark unhold locales && rm -rf /var/lib/apt/lists/* # buildkit
2025-12-03 14:09:00 UTC (buildkit.dockerfile.v0)COPY /usr/local /usr/local # buildkit
2025-12-03 14:09:11 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c python --version && pip --version # buildkit
2025-12-03 14:09:11 UTC (buildkit.dockerfile.v0)COPY /uv /uvx /bin/ # buildkit
2025-12-03 14:13:12 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends wait-for-it build-essential curl gnupg gcc g++ libcairo2-dev libpango1.0-dev libjpeg-dev libgif-dev librsvg2-dev && curl -fsSL https://deb.nodesource.com/setup_18.x | bash - && curl -qL https://www.npmjs.com/install.sh | sh - && apt-get install -y nodejs && curl -L --connect-timeout 60 -m 1800 https://fit2cloud-support.oss-cn-beijing.aliyuncs.com/xpack-license/get-validator-linux | sh && rm -rf /var/lib/apt/lists/* && chmod g+xr /usr/bin/ld.so && chmod g+x /usr/local/bin/python* # buildkit
2025-12-03 14:13:42 UTC (buildkit.dockerfile.v0)ENV DB_CLIENT=/opt/sqlbot/db_client
2025-12-03 14:13:42 UTC (buildkit.dockerfile.v0)ENV LD_LIBRARY_PATH=/opt/sqlbot/db_client/oracle_instant_client:
2025-12-03 14:13:42 UTC (buildkit.dockerfile.v0)ARG TARGETARCH=arm64
2025-12-03 14:13:42 UTC (buildkit.dockerfile.v0)RUN |1 TARGETARCH=arm64 /bin/sh -c apt-get update && apt-get install -y unzip libaio1 && mkdir -p ${DB_CLIENT} && if [ "$TARGETARCH" = "amd64" ]; then echo "Building for x86_64"; curl -L -o app.zip https://download.oracle.com/otn_software/linux/instantclient/2326000/instantclient-basic-linux.x64-23.26.0.0.0.zip; elif [ "$TARGETARCH" = "arm64" ]; then echo "Building for ARM64"; curl -L -o app.zip https://download.oracle.com/otn_software/linux/instantclient/2390000/instantclient-basic-linux.arm64-23.9.0.25.07.zip; fi && unzip app.zip -d ${DB_CLIENT} && rm app.zip && rm -rf /var/lib/apt/lists/* && mv ${DB_CLIENT}/instantclient* ${DB_CLIENT}/oracle_instant_client # buildkit
2025-12-03 14:13:42 UTC (buildkit.dockerfile.v0)ENV DM_HOME=/opt/dmdbms
2025-12-03 14:13:42 UTC (buildkit.dockerfile.v0)ENV LD_LIBRARY_PATH=/opt/dmdbms/bin:/opt/sqlbot/db_client/oracle_instant_client:
2025-12-03 14:13:46 UTC (buildkit.dockerfile.v0)RUN |1 TARGETARCH=arm64 /bin/sh -c curl -L -o dm.zip https://resource-fit2cloud-com.oss-cn-hangzhou.aliyuncs.com/sqlbot/dm/$TARGETARCH.zip && mkdir -p $DM_HOME/bin && unzip dm.zip -d $DM_HOME/bin && chmod -R +x $DM_HOME/bin && rm -rf dm.zip # buildkit
2025-12-04 03:14:23 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime && echo "Asia/Shanghai" > /etc/timezone # buildkit
2025-12-04 03:14:23 UTC (buildkit.dockerfile.v0)ENV PYTHONUNBUFFERED=1
2025-12-04 03:14:23 UTC (buildkit.dockerfile.v0)ENV SQLBOT_HOME=/opt/sqlbot
2025-12-04 03:14:23 UTC (buildkit.dockerfile.v0)ENV PYTHONPATH=/opt/sqlbot/app
2025-12-04 03:14:23 UTC (buildkit.dockerfile.v0)ENV PATH=/opt/sqlbot/app/.venv/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin
2025-12-04 03:14:23 UTC (buildkit.dockerfile.v0)ENV POSTGRES_DB=sqlbot
2025-12-04 03:14:23 UTC (buildkit.dockerfile.v0)ENV POSTGRES_USER=root
2025-12-04 03:14:23 UTC (buildkit.dockerfile.v0)ENV POSTGRES_PASSWORD=Password123@pg
2025-12-04 03:14:23 UTC (buildkit.dockerfile.v0)COPY start.sh /opt/sqlbot/app/start.sh # buildkit
2025-12-04 03:14:24 UTC (buildkit.dockerfile.v0)COPY g2-ssr/*.ttf /usr/share/fonts/truetype/liberation/ # buildkit
2025-12-04 03:26:54 UTC (buildkit.dockerfile.v0)COPY /opt/sqlbot /opt/sqlbot # buildkit
2025-12-04 03:26:57 UTC (buildkit.dockerfile.v0)COPY /app /opt/sqlbot/g2-ssr # buildkit
2025-12-04 03:26:59 UTC (buildkit.dockerfile.v0)COPY /opt/maxkb/app/model /opt/sqlbot/models # buildkit
2025-12-04 03:26:59 UTC (buildkit.dockerfile.v0)WORKDIR /opt/sqlbot/app
2025-12-04 03:26:59 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /opt/sqlbot/images /opt/sqlbot/g2-ssr # buildkit
2025-12-04 03:26:59 UTC (buildkit.dockerfile.v0)EXPOSE [3000/tcp 5432/tcp 8000/tcp 8001/tcp]
2025-12-04 03:26:59 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "curl -f http://localhost:8000 || exit 1"] "30s" "10s" "5s" "0s" '\x03'}
2025-12-04 03:26:59 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["sh" "start.sh"]
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.