TimescaleDB 镜像

Docker拉取命令

docker pull swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/timescale/timescaledb:2.16.1-pg16
docker tag  swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/timescale/timescaledb:2.16.1-pg16  docker.io/timescale/timescaledb:2.16.1-pg16

Containerd拉取命令

ctr images pull swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/timescale/timescaledb:2.16.1-pg16
ctr images tag  swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/timescale/timescaledb:2.16.1-pg16  docker.io/timescale/timescaledb:2.16.1-pg16

Shell快速替换命令

sed -i 's#timescale/timescaledb:2.16.1-pg16#swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/timescale/timescaledb:2.16.1-pg16#' deployment.yaml

Ansible快速分发-Docker

#ansible k8s -m shell -a 'docker pull swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/timescale/timescaledb:2.16.1-pg16 && docker tag  swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/timescale/timescaledb:2.16.1-pg16  docker.io/timescale/timescaledb:2.16.1-pg16'

Ansible快速分发-Containerd

#ansible k8s -m shell -a 'ctr images pull swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/timescale/timescaledb:2.16.1-pg16 && ctr images tag  swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/timescale/timescaledb:2.16.1-pg16  docker.io/timescale/timescaledb:2.16.1-pg16'

镜像构建历史

# 2024-08-06 23:33:01  20.73MB 执行命令并创建新的镜像层
RUN |7 OSS_ONLY= PG_VERSION=16 PGVECTOR_VERSION=v0.7.2 PGAI_VERSION=v0.3.0 PG_MAJOR_VERSION=16 TARGETARCH=amd64 TS_VERSION=2.16.1 /bin/sh -c set -ex     && apk add --no-cache --virtual .fetch-deps                 ca-certificates                 git                 openssl                 openssl-dev                 tar     && mkdir -p /build/     && git clone https://github.com/timescale/timescaledb /build/timescaledb         && apk add --no-cache --virtual .build-deps                 coreutils                 dpkg-dev dpkg                 gcc                 krb5-dev                 libc-dev                 make                 cmake                 util-linux-dev         && cd /build/timescaledb && rm -fr build     && git checkout ${TS_VERSION}     && ./bootstrap -DCMAKE_BUILD_TYPE=RelWithDebInfo -DREGRESS_CHECKS=OFF -DTAP_CHECKS=OFF -DGENERATE_DOWNGRADE_SCRIPT=ON -DWARNINGS_AS_ERRORS=OFF -DPROJECT_INSTALL_METHOD="docker"${OSS_ONLY}     && cd build && make install     && cd ~         && if [ "${OSS_ONLY}" != "" ]; then rm -f $(pg_config --pkglibdir)/timescaledb-tsl-*.so; fi     && apk del .fetch-deps .build-deps     && rm -rf /build     && sed -r -i "s/[#]*\s*(shared_preload_libraries)\s*=\s*'(.*)'/\1 = 'timescaledb,\2'/;s/,'/'/" /usr/local/share/postgresql/postgresql.conf.sample # buildkit
                        
# 2024-08-06 23:28:55  0.00B 定义构建参数
ARG TS_VERSION=2.16.1
                        
# 2024-08-06 23:28:55  121.14MB 复制新文件或目录到容器中
COPY /usr/local/share/postgresql/extension/timescaledb--*.sql /usr/local/share/postgresql/extension/ # buildkit
                        
# 2024-08-06 23:28:54  94.38MB 复制新文件或目录到容器中
COPY /usr/local/lib/postgresql/timescaledb-*.so /usr/local/lib/postgresql/ # buildkit
                        
# 2024-08-06 23:28:54  12.35MB 复制新文件或目录到容器中
COPY /go/bin/* /usr/local/bin/ # buildkit
                        
# 2024-08-06 23:28:54  5.85KB 复制新文件或目录到容器中
COPY docker-entrypoint-initdb.d/* /docker-entrypoint-initdb.d/ # buildkit
                        
# 2024-08-06 23:28:54  141.77MB 执行命令并创建新的镜像层
RUN |6 OSS_ONLY= PG_VERSION=16 PGVECTOR_VERSION=v0.7.2 PGAI_VERSION=v0.3.0 PG_MAJOR_VERSION=16 TARGETARCH=amd64 /bin/sh -c set -ex;     if [ "$PG_MAJOR_VERSION" -gt 15 ] && [ "$TARGETARCH" != "arm" ]; then         apk update;         apk add --no-cache --virtual .pgai-deps             git             build-base             cargo             python3-dev             py3-pip;         git clone --branch ${PGAI_VERSION} https://github.com/timescale/pgai.git /build/pgai;         cp /build/pgai/ai--*.sql /usr/local/share/postgresql/extension/;         cp /build/pgai/ai.control /usr/local/share/postgresql/extension/;         pip install --verbose --break-system-packages -r /build/pgai/requirements.txt;         apk del .pgai-deps;     fi # buildkit
                        
# 2024-08-06 23:27:46  0.00B 定义构建参数
ARG TARGETARCH=amd64
                        
# 2024-08-06 23:27:46  0.00B 定义构建参数
ARG PG_MAJOR_VERSION=16
                        
# 2024-08-06 23:27:46  0.00B 定义构建参数
ARG PGAI_VERSION=v0.3.0
                        
# 2024-08-06 23:27:46  6.84MB 执行命令并创建新的镜像层
RUN |3 OSS_ONLY= PG_VERSION=16 PGVECTOR_VERSION=v0.7.2 /bin/sh -c set -ex;     apk update;     apk add --no-cache --virtual .vector-deps         postgresql${PG_VERSION}-dev         git         build-base         clang15         llvm15-dev         llvm15;     git clone --branch ${PGVECTOR_VERSION} https://github.com/pgvector/pgvector.git /build/pgvector;     cd /build/pgvector;     make;     make install;     apk del .vector-deps # buildkit
                        
# 2024-08-06 23:26:27  0.00B 定义构建参数
ARG PGVECTOR_VERSION=v0.7.2
                        
# 2024-08-06 23:26:27  56.98MB 执行命令并创建新的镜像层
RUN |2 OSS_ONLY= PG_VERSION=16 /bin/sh -c set -ex;     apk update;     apk add --no-cache         postgresql${PG_VERSION}-plpython3 # buildkit
                        
# 2024-08-06 23:26:27  0.00B 定义构建参数
ARG PG_VERSION=16
                        
# 2024-08-06 23:26:27  0.00B 添加元数据标签
LABEL maintainer=Timescale https://www.timescale.com
                        
# 2024-08-06 23:26:27  0.00B 定义构建参数
ARG OSS_ONLY
                        
# 2024-06-04 04:57:56  0.00B 设置默认要执行的命令
CMD ["postgres"]
                        
# 2024-06-04 04:57:56  0.00B 声明容器运行时监听的端口
EXPOSE map[5432/tcp:{}]
                        
# 2024-06-04 04:57:56  0.00B 设置停止容器时发送的系统调用信号
STOPSIGNAL SIGINT
                        
# 2024-06-04 04:57:56  0.00B 配置容器启动时运行的命令
ENTRYPOINT ["docker-entrypoint.sh"]
                        
# 2024-06-04 04:57:56  23.00B 执行命令并创建新的镜像层
RUN /bin/sh -c ln -sT docker-ensure-initdb.sh /usr/local/bin/docker-enforce-initdb.sh # buildkit
                        
# 2024-06-04 04:57:56  14.96KB 复制新文件或目录到容器中
COPY docker-entrypoint.sh docker-ensure-initdb.sh /usr/local/bin/ # buildkit
                        
# 2024-06-04 04:57:56  0.00B 创建挂载点用于持久化数据或共享数据
VOLUME [/var/lib/postgresql/data]
                        
# 2024-06-04 04:57:56  0.00B 执行命令并创建新的镜像层
RUN /bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 1777 "$PGDATA" # buildkit
                        
# 2024-06-04 04:57:56  0.00B 设置环境变量 PGDATA
ENV PGDATA=/var/lib/postgresql/data
                        
# 2024-06-04 04:57:56  0.00B 执行命令并创建新的镜像层
RUN /bin/sh -c mkdir -p /var/run/postgresql && chown -R postgres:postgres /var/run/postgresql && chmod 3777 /var/run/postgresql # buildkit
                        
# 2024-06-04 04:57:56  59.25KB 执行命令并创建新的镜像层
RUN /bin/sh -c set -eux; 	cp -v /usr/local/share/postgresql/postgresql.conf.sample /usr/local/share/postgresql/postgresql.conf.sample.orig; 	sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/local/share/postgresql/postgresql.conf.sample; 	grep -F "listen_addresses = '*'" /usr/local/share/postgresql/postgresql.conf.sample # buildkit
                        
# 2024-06-04 04:57:56  234.45MB 执行命令并创建新的镜像层
RUN /bin/sh -c set -eux; 		wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; 	echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; 	mkdir -p /usr/src/postgresql; 	tar 		--extract 		--file postgresql.tar.bz2 		--directory /usr/src/postgresql 		--strip-components 1 	; 	rm postgresql.tar.bz2; 		apk add --no-cache --virtual .build-deps 		$DOCKER_PG_LLVM_DEPS 		bison 		coreutils 		dpkg-dev dpkg 		flex 		g++ 		gcc 		krb5-dev 		libc-dev 		libedit-dev 		libxml2-dev 		libxslt-dev 		linux-headers 		make 		openldap-dev 		openssl-dev 		perl-dev 		perl-ipc-run 		perl-utils 		python3-dev 		tcl-dev 		util-linux-dev 		zlib-dev 		icu-dev 		lz4-dev 		zstd-dev 	; 		cd /usr/src/postgresql; 	awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; 	grep '/var/run/postgresql' src/include/pg_config_manual.h.new; 	mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; 	gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; 	wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; 	wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; 		export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; 	export CLANG=clang-15; 		./configure 		--enable-option-checking=fatal 		--build="$gnuArch" 		--enable-integer-datetimes 		--enable-thread-safety 		--enable-tap-tests 		--disable-rpath 		--with-uuid=e2fs 		--with-pgport=5432 		--with-system-tzdata=/usr/share/zoneinfo 		--prefix=/usr/local 		--with-includes=/usr/local/include 		--with-libraries=/usr/local/lib 		--with-gssapi 		--with-ldap 		--with-tcl 		--with-perl 		--with-python 		--with-openssl 		--with-libxml 		--with-libxslt 		--with-icu 		--with-llvm 		--with-lz4 		--with-zstd 	; 	make -j "$(nproc)" world-bin; 	make install-world-bin; 	make -C contrib install; 		runDeps="$( 		scanelf --needed --nobanner --format '%n#p' --recursive /usr/local 			| tr ',' '\n' 			| sort -u 			| awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' 			| grep -v -e perl -e python -e tcl 	)"; 	apk add --no-cache --virtual .postgresql-rundeps 		$runDeps 		bash 		tzdata 		zstd 		icu-data-full 		$([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') 	; 	apk del --no-network .build-deps; 	cd /; 	rm -rf 		/usr/src/postgresql 		/usr/local/share/doc 		/usr/local/share/man 	; 		postgres --version # buildkit
                        
# 2024-06-04 04:57:56  0.00B 设置环境变量 DOCKER_PG_LLVM_DEPS
ENV DOCKER_PG_LLVM_DEPS=llvm15-dev 		clang15
                        
# 2024-06-04 04:57:56  0.00B 设置环境变量 PG_SHA256
ENV PG_SHA256=331963d5d3dc4caf4216a049fa40b66d6bcb8c730615859411b9518764e60585
                        
# 2024-06-04 04:57:56  0.00B 设置环境变量 PG_VERSION
ENV PG_VERSION=16.3
                        
# 2024-06-04 04:57:56  0.00B 设置环境变量 PG_MAJOR
ENV PG_MAJOR=16
                        
# 2024-06-04 04:57:56  0.00B 执行命令并创建新的镜像层
RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit
                        
# 2024-06-04 04:57:56  0.00B 设置环境变量 LANG
ENV LANG=en_US.utf8
                        
# 2024-06-04 04:57:56  4.00B 执行命令并创建新的镜像层
RUN /bin/sh -c set -eux; ln -svf gosu /usr/local/bin/su-exec; su-exec nobody true # backwards compatibility (removed in PostgreSQL 17+) # buildkit
                        
# 2024-06-04 04:57:56  2.60MB 执行命令并创建新的镜像层
RUN /bin/sh -c set -eux; 		apk add --no-cache --virtual .gosu-deps 		ca-certificates 		dpkg 		gnupg 	; 		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; 		apk del --no-network .gosu-deps; 		chmod +x /usr/local/bin/gosu; 	gosu --version; 	gosu nobody true # buildkit
                        
# 2024-06-04 04:57:56  0.00B 设置环境变量 GOSU_VERSION
ENV GOSU_VERSION=1.17
                        
# 2024-06-04 04:57:56  3.07KB 执行命令并创建新的镜像层
RUN /bin/sh -c set -eux; 	addgroup -g 70 -S postgres; 	adduser -u 70 -S -D -G postgres -H -h /var/lib/postgresql -s /bin/sh postgres; 	mkdir -p /var/lib/postgresql; 	chown -R postgres:postgres /var/lib/postgresql # buildkit
                        
# 2024-06-04 04:57:56  0.00B 
/bin/sh -c #(nop)  CMD ["/bin/sh"]
                        
# 2024-06-04 04:57:56  7.80MB 
/bin/sh -c #(nop) ADD file:99093095d62d0421541d882f9ceeddb2981fe701ec0aa9d2c08480712d5fed21 in / 
                        
                    

镜像信息

{
    "Id": "sha256:2bbb52e38008f164557c8aa5026e114b01cb309a288d6b48d594accd8708161c",
    "RepoTags": [
        "timescale/timescaledb:2.16.1-pg16",
        "swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/timescale/timescaledb:2.16.1-pg16"
    ],
    "RepoDigests": [
        "timescale/timescaledb@sha256:3adf01543c37b5b88d3c4998338e0f7f21cb3cdd02bbddea08b09bf60e2289b7",
        "swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/timescale/timescaledb@sha256:fc42939d9cb76c2b40fac5f48b5349ac2a059e5027b6555fa9941491ab536206"
    ],
    "Parent": "",
    "Comment": "buildkit.dockerfile.v0",
    "Created": "2024-08-06T15:33:01.551482786Z",
    "Container": "",
    "ContainerConfig": null,
    "DockerVersion": "",
    "Author": "",
    "Config": {
        "Hostname": "",
        "Domainname": "",
        "User": "",
        "AttachStdin": false,
        "AttachStdout": false,
        "AttachStderr": false,
        "ExposedPorts": {
            "5432/tcp": {}
        },
        "Tty": false,
        "OpenStdin": false,
        "StdinOnce": false,
        "Env": [
            "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
            "GOSU_VERSION=1.17",
            "LANG=en_US.utf8",
            "PG_MAJOR=16",
            "PG_VERSION=16.3",
            "PG_SHA256=331963d5d3dc4caf4216a049fa40b66d6bcb8c730615859411b9518764e60585",
            "DOCKER_PG_LLVM_DEPS=llvm15-dev \t\tclang15",
            "PGDATA=/var/lib/postgresql/data"
        ],
        "Cmd": [
            "postgres"
        ],
        "ArgsEscaped": true,
        "Image": "",
        "Volumes": {
            "/var/lib/postgresql/data": {}
        },
        "WorkingDir": "",
        "Entrypoint": [
            "docker-entrypoint.sh"
        ],
        "OnBuild": null,
        "Labels": {
            "maintainer": "Timescale https://www.timescale.com"
        },
        "StopSignal": "SIGINT"
    },
    "Architecture": "amd64",
    "Os": "linux",
    "Size": 699118114,
    "GraphDriver": {
        "Data": {
            "LowerDir": "/var/lib/docker/overlay2/4c3f55026f8a07d9f3880ae760a2a5210dc8ab52496a1a87bba538ecbdb13d54/diff:/var/lib/docker/overlay2/fb8f16f20770e095974f27dfd700de75372d81b64aaa15418adb1917879f596e/diff:/var/lib/docker/overlay2/f321dd42cdbec8036b8d53dc0794dbece3b917c81702198ed5dcd4f2ba9466fb/diff:/var/lib/docker/overlay2/7f5bbf5b1001c459353d5113510a06456a38cf0d120d6f6b787f725e61c58fa8/diff:/var/lib/docker/overlay2/cf599f12d34be79939d885a0f8e540e64d32df96c9bb7f2e9fa51c75d0ce184a/diff:/var/lib/docker/overlay2/4976ed1928619a313fe9ed5d1444dcfbd92801097e3753c72780b4315b7bcb17/diff:/var/lib/docker/overlay2/c8ed0de718ee1a2eed3307a998aaffabf0ac65916daa95550603750a9f326e2a/diff:/var/lib/docker/overlay2/f6f47b24cc2ee171236eee3d8b3676763f212a0a3b8cdbd525ba5c0ee12fe0ee/diff:/var/lib/docker/overlay2/646ad6c7bbcb35ea40bd7989dfb40202a3942b264eaa3c50ae6dc8ea0ae7f2a8/diff:/var/lib/docker/overlay2/9e74b30761c81d3635b780ba0f82410d2bbc781fa033a4ccd5ff20b36a93a87b/diff:/var/lib/docker/overlay2/82a7909cb96965dbf4b5141d83e9126adb79b54f02e0dd6902a1f033d76256e7/diff:/var/lib/docker/overlay2/c67a0aa9987480a127e268743ad3c80df2add22d2dc17fd83455c333cfa77985/diff:/var/lib/docker/overlay2/9d9d6104a95eec55aac969b2dbf2b5751a5381962b73abb8a3e3242ddefffbc4/diff:/var/lib/docker/overlay2/83ebca83d85d580e12fc5bad9745d067de8f3af462adf60206a210ea8bf97b9d/diff:/var/lib/docker/overlay2/2e71fd23b00bee94013351e9fb3a9c0dfd57d634761af8b64cfc3d55dd901090/diff:/var/lib/docker/overlay2/507e8b4b4676ab241651b70026369f967479f5c38c498d7b3720b14ff473beef/diff:/var/lib/docker/overlay2/a85188ec58ebff4ec896b6a1a0c6b1aa6484e54f6cff210549004c4bad2a1ab8/diff:/var/lib/docker/overlay2/2c592d65d79d2ca4305c72eccb7924de09b906468c80a32e61abf499edd57a29/diff",
            "MergedDir": "/var/lib/docker/overlay2/f6b5aff3ce15858d00d8bd00a5714a8222fc51a072c395c2d785f3e4cab890a0/merged",
            "UpperDir": "/var/lib/docker/overlay2/f6b5aff3ce15858d00d8bd00a5714a8222fc51a072c395c2d785f3e4cab890a0/diff",
            "WorkDir": "/var/lib/docker/overlay2/f6b5aff3ce15858d00d8bd00a5714a8222fc51a072c395c2d785f3e4cab890a0/work"
        },
        "Name": "overlay2"
    },
    "RootFS": {
        "Type": "layers",
        "Layers": [
            "sha256:78561cef0761903dd2f7d09856150a6d4fb48967a8f113f3e33d79effbf59a07",
            "sha256:8fdf397cda5ede3704a17c96f0b5e735f42370de14eaf86366aa27aedbc567c8",
            "sha256:e00a49c986ee842b50eb4440accf56c38330f2b33af93aafef5783b6bb0c0e53",
            "sha256:53f8b77d9e39328081aedb3c8ffb14487d3b3b1abd9480c4508c6de65b0e1e5c",
            "sha256:98e6ec3c6a76ce6c743ae4ef3463751ebb164b395c4a783f4987b74823a56086",
            "sha256:bcb20466f87f43d523c22909961d9f1aa9de687cdfa1094b876a8f826a9b7317",
            "sha256:dce4a1bad27b619e714ca45da94883b17216ba0b57fef5935900dfce0be91ccb",
            "sha256:e73f5b2506dd691dd10e38dbe0bc6885c0b1717ea486fc465b28f5975ddb306c",
            "sha256:51142921c39ef295233355267a4bfadd4a5fd05bb043b0d3bd1fc9b61c93c6ea",
            "sha256:def3a9ab0e1c3e2d2021390bf71ae67d5bfa77c24788cd5b84537aebae3506f5",
            "sha256:4ada0f65e9d0215b05d88ba70173a3dc8bbad8b616eb735b2d1b9228e2b00dd9",
            "sha256:2cfd19c713347750ca6f537f4d0e12cfb266d819926828cf8edd52d5b137d183",
            "sha256:a0ae7a646b29ff1214feb5eff9bb9ce60852ad429aa459f12a098e17da9954d4",
            "sha256:d1ff51985d6160292aa0082c8ab6abe4e832d630f65ad60ea7909b1dc7038ee7",
            "sha256:9dc67e2ebe8315e1a5bb1ee83e3c60019a47d8001904829448a87dcc608104c3",
            "sha256:52d5624e98a978942bf547ef5c49af14b5f4fcb78a4cca8e289da91edb07cd0b",
            "sha256:4e6494d29392d23f50b314e917fd73352a36b2111501a6811a1ad3a260b4e546",
            "sha256:e244cc03f133f7b07b0053b6cd65252cbc8e98d7f1bc475c352528ea1cdef3e8",
            "sha256:05db4b61e34aa738b48d6b726bf3b7bc64d868eafa243678dd1f7d34fc1ae40f"
        ]
    },
    "Metadata": {
        "LastTagTime": "2026-08-26T15:42:06.87570674+08:00"
    }
}