Namespace
dataease
Image / Tagsqlbot:dev
Content Digestsha256:836869ccec90be1c3df892ec050e611dc90960abb7ed858685568195884c5f0a
Details
2025-10-21 01:41:06 UTC
1.68 GB
Environment
GOSU_VERSION1.17
LANGen_US.utf8
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.62% (27.8 MB)
[#001] sha256:3166755df2cd1988f231f0033260fc94747f5435503225060769ea4ec3b06f07 - 0.0% (1.14 KB)
[#002] sha256:93c86b7657ed1289b28d79ebbab053d2c8abf7a3e5b27f446a33fcb81311cb0a - 0.25% (4.32 MB)
[#003] sha256:c1499316ffcfa748a10deee3ed7645645a01bc372a8fe9b9bd14e1cd0df5c464 - 0.08% (1.38 MB)
[#004] sha256:6e6162b82c961596fd81c96b0d027c6977b04856b344d4c6b37036fd25804592 - 0.45% (7.69 MB)
[#005] sha256:678fdefd6cc39131fa99ef3e532be8627d17e1b39a17b32b375c23584095d9be - 0.07% (1.14 MB)
[#006] sha256:7960bd43e7e7093fc87228eaf9f132681666766f6fada680c0a498256ce300c7 - 0.0% (116 Bytes)
[#007] sha256:1eef446a2d115c56650f364dc950fc80e4338b8141a9ac82ed6fdc1a34a7adca - 0.0% (3.07 KB)
[#008] sha256:717379dd4557593dd073a1d33e202a9b43a51fa7497284b3ad6f481345113536 - 6.27% (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.08% (1.38 MB)
[#016] sha256:13d73967262bdc92851aa5e79c5c5f571f20cf8f4caa29f07920a64e55884eda - 0.76% (13 MB)
[#017] sha256:75c1f8ffb689257d3ee1e6ae661065bfceca259d45d5f563f0c390b09d060719 - 0.17% (3 MB)
[#018] sha256:9ccd3912524189dae78e436f260e9bdc5b89bb641778724ceeaffd656ac21208 - 0.97% (16.6 MB)
[#019] sha256:b637e4227f37eb6bc306515b7017cab20f3a91e901779d97aff8ffec09293b4f - 10.54% (181 MB)
[#020] sha256:dacd2285f57059c4a3dc181827b7bf41bf59fbff238e02fe8e577c025daaf989 - 0.0% (194 Bytes)
[#021] sha256:f1879bb772d6dd2f8dd09229a35e7b1be1942af67fd53ad03eb04f8ab89b1a6c - 0.0% (434 Bytes)
[#022] sha256:e63fa6164a57ff50a00b2dcb8d15d2996079941404e5acd340f67d1a506dda91 - 0.85% (14.6 MB)
[#023] sha256:ea6050c58fb53f276ab157bab30586cbf449551f2ca6da39b12cfe5ef21f3aaa - 31.76% (545 MB)
[#024] sha256:04a39254c53088bec53400ba8fc805d15ce5b10b64cf113c4dc9520df8a5adf1 - 3.76% (64.5 MB)
[#025] sha256:d588f393ebee4d8aef8bd86823b301731d8cda1d8d2d33cebca264e2ccc5a3f8 - 42.36% (727 MB)
[#026] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#027] sha256:715274d883650cf331307f67b4e43fb699443d97f863a28eed9f35b315382f01 - 0.0% (139 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-09-17 01:11:29 UTC (buildkit.dockerfile.v0)COPY /usr/local /usr/local # buildkit
2025-09-17 01:11:30 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c python --version && pip --version # buildkit
2025-09-17 01:11:30 UTC (buildkit.dockerfile.v0)COPY /uv /uvx /bin/ # buildkit
2025-09-17 01:12:09 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-10-21 01:35:56 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime && echo "Asia/Shanghai" > /etc/timezone # buildkit
2025-10-21 01:35:56 UTC (buildkit.dockerfile.v0)ENV PYTHONUNBUFFERED=1
2025-10-21 01:35:56 UTC (buildkit.dockerfile.v0)ENV SQLBOT_HOME=/opt/sqlbot
2025-10-21 01:35:56 UTC (buildkit.dockerfile.v0)ENV PYTHONPATH=/opt/sqlbot/app
2025-10-21 01:35:56 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-10-21 01:35:56 UTC (buildkit.dockerfile.v0)ENV POSTGRES_DB=sqlbot
2025-10-21 01:35:56 UTC (buildkit.dockerfile.v0)ENV POSTGRES_USER=root
2025-10-21 01:35:56 UTC (buildkit.dockerfile.v0)ENV POSTGRES_PASSWORD=Password123@pg
2025-10-21 01:35:56 UTC (buildkit.dockerfile.v0)COPY start.sh /opt/sqlbot/app/start.sh # buildkit
2025-10-21 01:35:56 UTC (buildkit.dockerfile.v0)COPY g2-ssr/*.ttf /usr/share/fonts/truetype/liberation/ # buildkit
2025-10-21 01:40:51 UTC (buildkit.dockerfile.v0)COPY /opt/sqlbot /opt/sqlbot # buildkit
2025-10-21 01:41:02 UTC (buildkit.dockerfile.v0)COPY /app /opt/sqlbot/g2-ssr # buildkit
2025-10-21 01:41:06 UTC (buildkit.dockerfile.v0)COPY /opt/maxkb/app/model /opt/sqlbot/models # buildkit
2025-10-21 01:41:06 UTC (buildkit.dockerfile.v0)WORKDIR /opt/sqlbot/app
2025-10-21 01:41:06 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /opt/sqlbot/images /opt/sqlbot/g2-ssr # buildkit
2025-10-21 01:41:06 UTC (buildkit.dockerfile.v0)EXPOSE [3000/tcp 5432/tcp 8000/tcp 8001/tcp]
2025-10-21 01:41:06 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "curl -f http://localhost:8000 || exit 1"] "30s" "10s" "5s" "0s" '\x03'}
2025-10-21 01:41:06 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["sh" "start.sh"]
Details
2025-10-21 01:48:10 UTC
1.54 GB
Environment
GOSU_VERSION1.17
LANGen_US.utf8
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.76% (27.8 MB)
[#001] sha256:6f22bf4a69c67725a5d28659467a9f4119ed414adf8a1d433e11ad80206e7a29 - 0.0% (1.14 KB)
[#002] sha256:361ee65475462ea3e8ee78a207e0ee11b503288d0fc59ca7e79ac316ec6acc04 - 0.27% (4.29 MB)
[#003] sha256:d686f5a8767e8f7119f4019c78e95b41922a788f6adf346700ad86916e3f0d47 - 0.08% (1.31 MB)
[#004] sha256:e8c4da94471816abaff082b723798940778c0d6e9ba39ca35822ae23757628b1 - 0.49% (7.69 MB)
[#005] sha256:30dd948fe7b916f24497e0aa4ac3ea5f654f2ec18fecaf144b35e44757fcc0f5 - 0.07% (1.06 MB)
[#006] sha256:0c9e7f843ae66f3ff0fb7f0e9b43b16750e2dff4f3d8bb23e783ba6c4e9faa04 - 0.0% (116 Bytes)
[#007] sha256:3bb81ba96e939b60e2849bd3e78c77085a5b656b0da6722c19eec786712cb1a7 - 0.0% (3.07 KB)
[#008] sha256:dd7b64205bd3a8c57e5c34d5246ef6e204f453dee3fd18f61b81b1586a313bb9 - 6.71% (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:ddb435d6a73d88764ae55254a8d1b1bc60b0f120be6448d3c7688d918ced663f - 0.82% (13 MB)
[#017] sha256:f9016f66c50697ef9689f9d8867ea2016894a055fb864ef0ca575f5da689dded - 0.19% (3 MB)
[#018] sha256:8dbc8274cef55b44399706abbd68010fc20d1c0f04f8f08056682190211865fd - 1.0% (15.7 MB)
[#019] sha256:38e121412e7cc801ee15d33da39d1825b24d0e475a75f57c130acfcdc0d8e572 - 11.03% (174 MB)
[#020] sha256:a7884d7f3d9781433e5b5c12b61e44c2e019927dcb4071fe756c6fb5600bb356 - 0.0% (192 Bytes)
[#021] sha256:8967b23253e948301744409fb4adb46de775f33fe632ae9455adb0045b4b2b6f - 0.0% (434 Bytes)
[#022] sha256:f0e33f6287255600653ba9b56b1b4c6399a07656133b592fc2aac02fa2bfdb4c - 0.93% (14.6 MB)
[#023] sha256:fd7535d4fe8deb4e94530af618ac4b5a3c320b2cd59ee9a08ba2566c1e54afae - 29.39% (464 MB)
[#024] sha256:abd38d9c3a642492b1a64c37cbe4bf531b29266af2d586b41447f691b1f0846a - 1.13% (17.8 MB)
[#025] sha256:e9e2be043fdcd3cba04f147cbbb6a1b476bb1203577221b3ab3391891d483f84 - 46.05% (727 MB)
[#026] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#027] sha256:7990303b76ffefbdc6dc730776bd0ca8b63e3d9dcc5f2efeb3114dfc8bfd4b7b - 0.0% (138 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-09-17 01:11:28 UTC (buildkit.dockerfile.v0)COPY /usr/local /usr/local # buildkit
2025-09-17 01:11:37 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c python --version && pip --version # buildkit
2025-09-17 01:11:37 UTC (buildkit.dockerfile.v0)COPY /uv /uvx /bin/ # buildkit
2025-09-17 01:15:35 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-10-21 01:35:54 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime && echo "Asia/Shanghai" > /etc/timezone # buildkit
2025-10-21 01:35:55 UTC (buildkit.dockerfile.v0)ENV PYTHONUNBUFFERED=1
2025-10-21 01:35:55 UTC (buildkit.dockerfile.v0)ENV SQLBOT_HOME=/opt/sqlbot
2025-10-21 01:35:55 UTC (buildkit.dockerfile.v0)ENV PYTHONPATH=/opt/sqlbot/app
2025-10-21 01:35:55 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-10-21 01:35:55 UTC (buildkit.dockerfile.v0)ENV POSTGRES_DB=sqlbot
2025-10-21 01:35:55 UTC (buildkit.dockerfile.v0)ENV POSTGRES_USER=root
2025-10-21 01:35:55 UTC (buildkit.dockerfile.v0)ENV POSTGRES_PASSWORD=Password123@pg
2025-10-21 01:35:55 UTC (buildkit.dockerfile.v0)COPY start.sh /opt/sqlbot/app/start.sh # buildkit
2025-10-21 01:35:55 UTC (buildkit.dockerfile.v0)COPY g2-ssr/*.ttf /usr/share/fonts/truetype/liberation/ # buildkit
2025-10-21 01:48:03 UTC (buildkit.dockerfile.v0)COPY /opt/sqlbot /opt/sqlbot # buildkit
2025-10-21 01:48:08 UTC (buildkit.dockerfile.v0)COPY /app /opt/sqlbot/g2-ssr # buildkit
2025-10-21 01:48:10 UTC (buildkit.dockerfile.v0)COPY /opt/maxkb/app/model /opt/sqlbot/models # buildkit
2025-10-21 01:48:10 UTC (buildkit.dockerfile.v0)WORKDIR /opt/sqlbot/app
2025-10-21 01:48:10 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /opt/sqlbot/images /opt/sqlbot/g2-ssr # buildkit
2025-10-21 01:48:10 UTC (buildkit.dockerfile.v0)EXPOSE [3000/tcp 5432/tcp 8000/tcp 8001/tcp]
2025-10-21 01:48:10 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "curl -f http://localhost:8000 || exit 1"] "30s" "10s" "5s" "0s" '\x03'}
2025-10-21 01:48:10 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.