docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1 linux/amd64

docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1 - 国内下载镜像源 浏览次数:9

这是一个包含PostgreSQL数据库、PostGIS空间扩展和TimescaleDB时间序列数据库的Docker镜像。

源镜像 docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1
国内镜像 swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1
镜像ID sha256:2f6e04202642a0710aafad0bdbcf245c40b4be74753d3c378aaae66e5f1f8548
镜像TAG 14.8-3.3.4-2.11.1
大小 483.93MB
镜像源 docker.io
项目信息 Docker-Hub主页 🚀项目TAG 🚀
CMD postgres
启动入口 docker-entrypoint.sh
工作目录
OS/平台 linux/amd64
浏览量 9 次
贡献者 zf********4@outlook.com
镜像创建 2023-07-30T19:55:48.00102904Z
同步时间 2025-06-27 16:57
更新时间 2025-06-28 03:49
开放端口
5432/tcp
目录挂载
/var/lib/postgresql/data
环境变量
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin LANG=en_US.utf8 PG_MAJOR=14 PG_VERSION=14.8 PG_SHA256=39d38f0030737ed03835debeefee3b37d335462ce4995e2497bc38d621ebe45a DOCKER_PG_LLVM_DEPS=llvm15-dev clang15 PGDATA=/var/lib/postgresql/data ALPINE_VERSION=v3.18 POSTGIS_VERSION=3.3.4 POSTGIS_SHA256=68507aa4ab7f9f7218fcefdcdd989911415e5f670128eb33acbbb362a24a998e TIMESCALEDB_VERSION=2.11.1 TIMESCALEDB_SHA256=06a653881dd2460a9c9007dd823be8827ef83fae90a4b628d0b0d5066f60f496

Docker拉取命令

docker pull swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1
docker tag  swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1  docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1

Containerd拉取命令

ctr images pull swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1
ctr images tag  swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1  docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1

Shell快速替换命令

sed -i 's#pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1#swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1#' deployment.yaml

Ansible快速分发-Docker

#ansible k8s -m shell -a 'docker pull swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1 && docker tag  swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1  docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1'

Ansible快速分发-Containerd

#ansible k8s -m shell -a 'ctr images pull swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1 && ctr images tag  swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1  docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1'

镜像构建历史


# 2023-07-31 03:55:48  158.00B 
/bin/sh -c #(nop) COPY file:0eed5292f096fef84bd5a4c6cb6a5e329134e5227f0b4dd63777cd4e076d9601 in /docker-entrypoint-initdb.d/3.postgres.sh 
                        
# 2023-07-31 03:55:47  564.00B 
/bin/sh -c #(nop) COPY file:78a816bc3540fe31d7fdd72245c2f4e24e7e8e1d2f062e82558ece1bc6d64acb in /docker-entrypoint-initdb.d/2.timescaledb.sh 
                        
# 2023-07-31 03:55:46  595.00B 
/bin/sh -c #(nop) COPY file:d3b2e88d1df83525255660fb3c35f24a996fd7698bd7f5fbd25b10a4f178c82a in /docker-entrypoint-initdb.d/1.postgis.sh 
                        
# 2023-07-31 03:55:44  14.56MB 
/bin/sh -c set -ex     && apk add --no-cache --virtual .fetch-deps         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/main         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/community         build-base         ca-certificates         git         tar     && apk add --no-cache --virtual .build-deps         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/main         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/community         make         cmake         gcc         clang         clang-dev         llvm-dev         dpkg         dpkg-dev         util-linux-dev         libc-dev         coreutils         krb5-dev     && apk add --no-cache --virtual .timescaledb-rundeps         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/main         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/community         openssl         openssl-dev         && wget -O timescaledb.tar.gz "https://github.com/timescale/timescaledb/archive/$TIMESCALEDB_VERSION.tar.gz"     && echo "$TIMESCALEDB_SHA256 *timescaledb.tar.gz" | sha256sum -c -     && mkdir -p /usr/src/timescaledb     && tar --extract --file timescaledb.tar.gz --directory /usr/src/timescaledb --strip-components 1     && rm timescaledb.tar.gz         && cd /usr/src/timescaledb     && ./bootstrap -DPROJECT_INSTALL_METHOD="docker" -DREGRESS_CHECKS=OFF     && cd ./build && make install         && cd /     && rm -rf /usr/src/timescaledb     && apk del .fetch-deps .build-deps     && sed -r -i "s/[#]*\s*(shared_preload_libraries)\s*=\s*'(.*)'/\1 = 'timescaledb,\2'/;s/,'/'/" /usr/local/share/postgresql/postgresql.conf.sample
                        
# 2023-07-31 03:54:28  0.00B 
/bin/sh -c #(nop)  ENV TIMESCALEDB_SHA256=06a653881dd2460a9c9007dd823be8827ef83fae90a4b628d0b0d5066f60f496
                        
# 2023-07-31 03:54:27  0.00B 
/bin/sh -c #(nop)  ENV TIMESCALEDB_VERSION=2.11.1
                        
# 2023-07-31 03:54:27  234.08MB 
/bin/sh -c set -ex         && apk add --no-cache --virtual .fetch-deps         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/main         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/community         build-base         ca-certificates         openssl         git         tar     && apk add --no-cache --virtual .build-deps         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/main         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/community         make         automake         autoconf         libtool         file         gcc         g++         perl         clang15         clang15-dev         llvm15         llvm15-dev         libxml2-dev                 json-c-dev         geos-dev         gdal-dev         proj-dev         protobuf-c-dev         postgresql-dev     && apk add --no-cache --virtual .postgis-rundeps         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/main         --repository http://dl-cdn.alpinelinux.org/alpine/$ALPINE_VERSION/community         json-c         geos         gdal         proj         protobuf-c         && wget -O postgis.tar.gz "https://github.com/postgis/postgis/archive/$POSTGIS_VERSION.tar.gz"     && echo "$POSTGIS_SHA256 *postgis.tar.gz" | sha256sum -c -     && mkdir -p /usr/src/postgis     && tar --extract --file postgis.tar.gz --directory /usr/src/postgis --strip-components 1     && rm postgis.tar.gz         && cd /usr/src/postgis     && ./autogen.sh     && ./configure     && make -s     && make -s install     && cd /     && rm -rf /usr/src/postgis     && apk del .fetch-deps .build-deps
                        
# 2023-07-31 03:51:39  0.00B 
/bin/sh -c #(nop)  ENV POSTGIS_SHA256=68507aa4ab7f9f7218fcefdcdd989911415e5f670128eb33acbbb362a24a998e
                        
# 2023-07-31 03:51:38  0.00B 
/bin/sh -c #(nop)  ENV POSTGIS_VERSION=3.3.4
                        
# 2023-07-31 03:51:37  0.00B 
/bin/sh -c #(nop)  ENV ALPINE_VERSION=v3.18
                        
# 2023-07-31 03:51:36  0.00B 
/bin/sh -c #(nop)  MAINTAINER Sergei Pikhovkin
                        
# 2023-06-15 05:25:34  0.00B 
/bin/sh -c #(nop)  CMD ["postgres"]
                        
# 2023-06-15 05:25:34  0.00B 
/bin/sh -c #(nop)  EXPOSE 5432
                        
# 2023-06-15 05:25:34  0.00B 
/bin/sh -c #(nop)  STOPSIGNAL SIGINT
                        
# 2023-06-15 05:25:34  0.00B 
/bin/sh -c #(nop)  ENTRYPOINT ["docker-entrypoint.sh"]
                        
# 2023-06-15 05:25:34  12.49KB 
/bin/sh -c #(nop) COPY file:e635913e9467265f505455bc3f08bed37d67ce6597a1f10365f8faf79f09b654 in /usr/local/bin/ 
                        
# 2023-06-15 05:25:34  0.00B 
/bin/sh -c #(nop)  VOLUME [/var/lib/postgresql/data]
                        
# 2023-06-15 05:25:34  0.00B 
/bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 1777 "$PGDATA"
                        
# 2023-06-15 05:25:33  0.00B 
/bin/sh -c #(nop)  ENV PGDATA=/var/lib/postgresql/data
                        
# 2023-06-15 05:25:33  0.00B 
/bin/sh -c mkdir -p /var/run/postgresql && chown -R postgres:postgres /var/run/postgresql && chmod 3777 /var/run/postgresql
                        
# 2023-06-15 05:25:33  57.39KB 
/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
                        
# 2023-06-15 05:25:32  227.88MB 
/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 	; 		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-gnu-ld 		--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 	; 	make -j "$(nproc)" world; 	make install-world; 	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 		su-exec 		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
                        
# 2023-06-15 05:22:53  0.00B 
/bin/sh -c #(nop)  ENV DOCKER_PG_LLVM_DEPS=llvm15-dev 		clang15
                        
# 2023-06-15 05:22:53  0.00B 
/bin/sh -c #(nop)  ENV PG_SHA256=39d38f0030737ed03835debeefee3b37d335462ce4995e2497bc38d621ebe45a
                        
# 2023-06-15 05:22:53  0.00B 
/bin/sh -c #(nop)  ENV PG_VERSION=14.8
                        
# 2023-06-15 05:22:53  0.00B 
/bin/sh -c #(nop)  ENV PG_MAJOR=14
                        
# 2023-06-15 05:10:07  0.00B 
/bin/sh -c mkdir /docker-entrypoint-initdb.d
                        
# 2023-06-15 05:10:06  0.00B 
/bin/sh -c #(nop)  ENV LANG=en_US.utf8
                        
# 2023-06-15 05:10:06  4.71KB 
/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
                        
# 2023-06-15 04:41:59  0.00B 
/bin/sh -c #(nop)  CMD ["/bin/sh"]
                        
# 2023-06-15 04:41:58  7.33MB 
/bin/sh -c #(nop) ADD file:1da756d12551a0e3e793e02ef87432d69d4968937bd11bed0af215db19dd94cd in / 
                        
                    

镜像信息

{
    "Id": "sha256:2f6e04202642a0710aafad0bdbcf245c40b4be74753d3c378aaae66e5f1f8548",
    "RepoTags": [
        "pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1",
        "swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1"
    ],
    "RepoDigests": [
        "pikhovkin/postgresql-postgis-timescaledb@sha256:36e9727a4acabbe7a83e62bfd67ab779a113d1bc0134b245178580e7e011ad70",
        "swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/pikhovkin/postgresql-postgis-timescaledb@sha256:36e9727a4acabbe7a83e62bfd67ab779a113d1bc0134b245178580e7e011ad70"
    ],
    "Parent": "",
    "Comment": "",
    "Created": "2023-07-30T19:55:48.00102904Z",
    "Container": "",
    "ContainerConfig": null,
    "DockerVersion": "20.10.25+azure-2",
    "Author": "Sergei Pikhovkin",
    "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",
            "LANG=en_US.utf8",
            "PG_MAJOR=14",
            "PG_VERSION=14.8",
            "PG_SHA256=39d38f0030737ed03835debeefee3b37d335462ce4995e2497bc38d621ebe45a",
            "DOCKER_PG_LLVM_DEPS=llvm15-dev \t\tclang15",
            "PGDATA=/var/lib/postgresql/data",
            "ALPINE_VERSION=v3.18",
            "POSTGIS_VERSION=3.3.4",
            "POSTGIS_SHA256=68507aa4ab7f9f7218fcefdcdd989911415e5f670128eb33acbbb362a24a998e",
            "TIMESCALEDB_VERSION=2.11.1",
            "TIMESCALEDB_SHA256=06a653881dd2460a9c9007dd823be8827ef83fae90a4b628d0b0d5066f60f496"
        ],
        "Cmd": [
            "postgres"
        ],
        "Image": "sha256:533409038962efb2a1653969e052fff600b291057fc2244fc28c1b6f5f151f3c",
        "Volumes": {
            "/var/lib/postgresql/data": {}
        },
        "WorkingDir": "",
        "Entrypoint": [
            "docker-entrypoint.sh"
        ],
        "OnBuild": null,
        "Labels": null,
        "StopSignal": "SIGINT"
    },
    "Architecture": "amd64",
    "Os": "linux",
    "Size": 483925788,
    "GraphDriver": {
        "Data": {
            "LowerDir": "/var/lib/docker/overlay2/5f8305d5d71c32c0c678e9486ae111c84099b32cb102ba18c562d1c444ede4c3/diff:/var/lib/docker/overlay2/8bba0b167e4c60eff304dc4c74ec19b6a96608d959b06f73419aeef65a738fa4/diff:/var/lib/docker/overlay2/12667b862bd12884cb829721e0fba9da127b62136eb842d0020158bc82f5adf0/diff:/var/lib/docker/overlay2/989be941ccc4659833a83ee86bb081e8f6957ed55b219ca427be438f8d23b7cf/diff:/var/lib/docker/overlay2/2d08905a8ba994de518503ed461758073ac30506509812044c0a28a02b4faedc/diff:/var/lib/docker/overlay2/0bac0250a1809a8ae757e76741acf4d2befa762810f246a8e45d7e63b4073a9a/diff:/var/lib/docker/overlay2/90f247c1057bf5cc865ad392cc930e8c56aaaac36f330f306875b1e3b48ba5e3/diff:/var/lib/docker/overlay2/854c618835586a4a6722a9c7ca778ea650ab1aea12bd4288f66744c7336ec395/diff:/var/lib/docker/overlay2/9765c34129803efcbbcdece6189031985b7497cc92c9b06fbffc927e4a9bf92e/diff:/var/lib/docker/overlay2/03b6e339e814763c9832885b5da5100811e91f8a3868aeb876ecc3dde6cf2c9e/diff:/var/lib/docker/overlay2/5b8b6f0579ca1193f7dd5c8f3a74358467c8d8beb3e9daf3b2ab436cce800c7a/diff:/var/lib/docker/overlay2/c67c67d126c2ba4949dc9645614fa0336ef09c5d0b0ad7876556f02789b8673d/diff",
            "MergedDir": "/var/lib/docker/overlay2/89d355d47c04b28cb8d2e6016ce80bb389fa39ce345364effc7cb54b8ffca9aa/merged",
            "UpperDir": "/var/lib/docker/overlay2/89d355d47c04b28cb8d2e6016ce80bb389fa39ce345364effc7cb54b8ffca9aa/diff",
            "WorkDir": "/var/lib/docker/overlay2/89d355d47c04b28cb8d2e6016ce80bb389fa39ce345364effc7cb54b8ffca9aa/work"
        },
        "Name": "overlay2"
    },
    "RootFS": {
        "Type": "layers",
        "Layers": [
            "sha256:78a822fe2a2d2c84f3de4a403188c45f623017d6a4521d23047c9fbb0801794c",
            "sha256:921828208720f4161341ad36d602d31a770d46727781aa8cb5893dba29051e65",
            "sha256:fe4fa537f778647a1f3dafa5f67f56e5127ac266e925fea89622420a46ac2dc7",
            "sha256:ae6f8488991d11617dae53427ebd842a5e01e92b77410e0ff7017bfe00005468",
            "sha256:f4b5a53bd86042d747b353beebe8c9f2f9479d279461f39bca9cb6567550a51c",
            "sha256:e52c07e176358d5fee27b91f0d291c723cbaafe4e0668ddc8749662ca0b8b9db",
            "sha256:da38808e245421364378720ad2e2924b91538653dfaa6615fd52c1ddbbad5bb8",
            "sha256:ed2ea4fb903c18268be17b5a442e4d24a67b37149ae79f9ac9fd1c6514b889d6",
            "sha256:dbf41963779dcb20b2b3e86fdc8901148f192c76f225b0755ae4e77df89b59d3",
            "sha256:ba92494689a4f2153ab2858f0fca9cc5d1c887efc2a61fadfbad5f0b92070009",
            "sha256:998c8f3180abb82e3be1081fd7d362bcf625adfeb5d1bf84adc0f0a627d1ffeb",
            "sha256:bdedf50897c3e9957934ba6ae7c94dc70d39ed31aaa6901f1ad2ee59084e2952",
            "sha256:9b28aac1fa06b41e044177bccfdbbcdd473441478cb427a2eb7f418fbc227460"
        ]
    },
    "Metadata": {
        "LastTagTime": "2025-06-27T16:57:27.697467354+08:00"
    }
}

更多版本

docker.io/pikhovkin/postgresql-postgis-timescaledb:14.8-3.3.4-2.11.1

linux/amd64 docker.io483.93MB2025-06-27 16:57
8