postgis

postgis/postgis

postgis

PostGIS是PostgreSQL对象关系型数据库的空间数据库扩展器,它为PostgreSQL增添了对空间数据类型(如点、线、面、几何体集合等)的支持,提供空间索引功能以提升空间数据查询效率,并集成了丰富的空间分析函数(包括距离计算、缓冲区分析、叠加操作等),使PostgreSQL能够高效存储、管理与分析空间数据,广泛应用于地理信息系统(GIS)、位置服务、地图绘制等领域。

301 次收藏下载次数: 0状态:社区镜像维护者:postgis仓库类型:镜像最近更新:6 天前
让 AI 帮你使用轩辕镜像?

如果你使用 DeepSeek元宝 AI、Copilot、ChatGPT 等 AI 工具,协助配置轩辕镜像、编写 docker pull 命令、修改 Docker Compose 镜像地址、配置镜像加速、排查镜像拉取失败、分析报错日志等问题,请先让 AI 阅读并遵守轩辕镜像的规则文档。

只需在 AI 对话中先发送下面这句话即可:

请先完整阅读并严格遵守以下文档中的全部规则与要求:

https://xuanyuan.cloud/agents.md

在未充分阅读并理解该文档前,不要生成任何命令、配置、修改建议、故障排查方案或技术回答。后续所有输出都必须严格以该文档中的规范为最高优先级执行。

查看 agents.md 用法指南与完整示范。国内用户首推 元宝 AIDeepSeek 的深度思考模式,不推荐豆包 AI;Cursor 等编辑器可在对话 @ 该链接,或加入 User Rules。 若 AI 无法访问外链,可 打开说明文档 复制全文粘贴。文档会随站点更新,复制内容可能过期,建议定期检查。

下载命令
点击查看

postgis/postgis

⚠️ Breaking change (PostgreSQL 18+): Default VOLUME path changed to /var/lib/postgresql

The postgis/postgis image provides tags for running Postgres with http://postgis.net/ extensions installed. This image is based on the official https://registry.hub.docker.com/_/postgres/ image and provides Debian and Alpine variants for PostGIS 3.5.x and 3.6.x that are compatible with PostgreSQL versions 14, 15, 16, 17 and 18. Additionally, image variants are provided for PostgreSQL 17 and 18, built with PostGIS (and its dependencies) from their respective master branches. These are tagged as 17-master and 18-master.

This image ensures that the default database created by the parent postgres image will have the following extensions installed:

installed extensionshttps://github.com/postgis/docker-postgis/blob/master/initdb-postgis.sh
postgisyes
postgis_topologyyes
postgis_tiger_geocoderyes, for PostGIS < 3.7
postgis_rasterno (available)
postgis_sfcgalno (available)
address_standardizerno (available)
address_standardizer_data_usno (available)

For PostGIS 3.5 and 3.6 images, address_standardizer and address_standardizer_data_us are available from the PostGIS package but are not initialized by default. For *-master images tracking PostGIS >= 3.7, address_standardizer is installed separately from https://github.com/postgis/address_standardizer, while postgis_tiger_geocoder is no longer provided by PostGIS.

Unless -e POSTGRES_DB is passed to the container at startup time, this database will be named after the admin user (either postgres or the user specified with -e POSTGRES_USER). If you would prefer to use the older template database mechanism for enabling PostGIS, the image also provides a PostGIS-enabled template database called template_postgis.

Versions (2026-06-19)

Supported architecture: amd64 (x86-64)

Recommended versions for new users are:

  • postgis/postgis:18-3.6
    • ⚠️ Uses VOLUME path /var/lib/postgresql (changed in PostgreSQL 18+)
  • postgis/postgis:17-3.5
    • Uses legacy VOLUME path /var/lib/postgresql/data

Debian based (recommended)

  • This Docker-PostGIS image has a cautious release cycle to guarantee high stability.
    • By "cautious", we mean it does not always have the latest versions of geos, proj, gdal, and sfcgal packages.
  • We use PostGIS, geos, proj, gdal, and sfcgal packages from the Debian repository.
    • In the Debian Bullseye repository (for PostgreSQL 14 to 17), the versions are:
      • geos=3.9
      • gdal=3.2
      • proj=7.2
      • sfcgal=1.3.9
    • In the Debian Trixie repository (for PostgreSQL 18+), the versions are:
      • geos=3.13
      • gdal=3.10
      • proj=9.6
      • sfcgal2=2.0
  • This version is easy to extend and has matured over time.
DockerHub imageDockerfileOSPostgresPostGIS
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=14-3.5https://github.com/postgis/docker-postgis/blob/master/14-3.5/Dockerfiledebian:bullseye143.5.2
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=15-3.5https://github.com/postgis/docker-postgis/blob/master/15-3.5/Dockerfiledebian:bullseye153.5.2
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=16-3.5https://github.com/postgis/docker-postgis/blob/master/16-3.5/Dockerfiledebian:bullseye163.5.2
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=17-3.5https://github.com/postgis/docker-postgis/blob/master/17-3.5/Dockerfiledebian:bullseye173.5.2
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=18-3.6https://github.com/postgis/docker-postgis/blob/master/18-3.6/Dockerfiledebian:trixie183.6.4

Alpine based

  • The base operating system is https://alpinelinux.org/. It is designed to be small, simple, and secure, and it's based on https://musl.libc.org/.
  • In the Alpine 3.24 version, the package versions are:
    • geos=3.14.1
    • gdal=3.13.0
    • proj=9.8.1
    • sfcgal=2.2.0
  • PostGIS is compiled from source, making it a bit more challenging to extend.
DockerHub imageDockerfileOSPostgresPostGIS
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=14-3.5-alpinehttps://github.com/postgis/docker-postgis/blob/master/14-3.5/alpine/Dockerfilealpine:3.24143.5.7
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=15-3.5-alpinehttps://github.com/postgis/docker-postgis/blob/master/15-3.5/alpine/Dockerfilealpine:3.24153.5.7
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=16-3.5-alpinehttps://github.com/postgis/docker-postgis/blob/master/16-3.5/alpine/Dockerfilealpine:3.24163.5.7
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=17-3.5-alpinehttps://github.com/postgis/docker-postgis/blob/master/17-3.5/alpine/Dockerfilealpine:3.24173.5.7
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=17-3.6-alpinehttps://github.com/postgis/docker-postgis/blob/master/17-3.6/alpine/Dockerfilealpine:3.24173.6.4
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=18-3.6-alpinehttps://github.com/postgis/docker-postgis/blob/master/18-3.6/alpine/Dockerfilealpine:3.24183.6.4

Test images

  • We provide alpha, beta, release candidate (rc), and development (identified as ~master) versions.
  • For *-master images, the template is updated manually, which might lead to a delay of a few weeks sometimes.
  • Current PostGIS 3.7 development images use the up-to-date CGAL revision from the 6.1.x-branch.
  • Starting with PostGIS >= 3.7, PostGIS itself no longer includes the address_standardizer and postgis_tiger_geocoder extensions. The *-master images install address_standardizer separately from https://github.com/postgis/address_standardizer and run its upstream-style installcheck. See: https://lists.osgeo.org/pipermail/postgis-devel/2026-February/030730.html
  • They also install the h3 and h3_postgis extensions from the main branch of https://github.com/postgis/h3-pg; because this is a development branch, their extension version may appear as unreleased.
DockerHub imageDockerfileOSPostgresPostGIS
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=16-masterhttps://github.com/postgis/docker-postgis/blob/master/16-master/Dockerfiledebian:trixie16development: postgis, geos, proj, gdal
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=17-masterhttps://github.com/postgis/docker-postgis/blob/master/17-master/Dockerfiledebian:trixie17development: postgis, geos, proj, gdal
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=18-masterhttps://github.com/postgis/docker-postgis/blob/master/18-master/Dockerfiledebian:trixie18development: postgis, geos, proj, gdal
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=19beta1-3.6https://github.com/postgis/docker-postgis/blob/master/19beta1-3.6/Dockerfiledebian:trixie19beta13.6.4
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=19beta1-3.6-alpinehttps://github.com/postgis/docker-postgis/blob/master/19beta1-3.6/alpine/Dockerfilealpine:3.2419beta13.6.4
https://registry.hub.docker.com/r/postgis/postgis/tags?page=1&name=19beta1-masterhttps://github.com/postgis/docker-postgis/blob/master/19beta1-master/Dockerfiledebian:trixie19beta1development: postgis, geos, proj, gdal

Usage

In order to run a basic container capable of serving a PostGIS-enabled database, start a container as follows:

sh
docker run --name some-postgis -e POSTGRES_PASSWORD=mysecretpassword -d postgis/postgis

For more detailed instructions about how to start and control your Postgres container, see the documentation for the https://registry.hub.docker.com/_/postgres/.

Once you have started a database container, you can then connect to the database either directly on the running container:

sh
docker exec -ti some-postgis psql -U postgres

... or starting a new container to run as a client. In this case you can use a user-defined network to link both containers:

sh
docker network create some-network

# Server container
docker run --name some-postgis --network some-network -e POSTGRES_PASSWORD=mysecretpassword -d postgis/postgis

# Client container
docker run -it --rm --network some-network postgis/postgis psql -h some-postgis -U postgres

Check the documentation on the https://registry.hub.docker.com/_/postgres/ and https://docs.docker.com/network/ for more details and alternatives on connecting different containers.

See http://postgis.net/docs/postgis_installation.html#create_new_db_extensions for more details on your options for creating and using a spatially-enabled database.

Supported Environment Variables

Since the docker-postgis repository is an extension of the official Docker PostgreSQL repository, all environment variables supported there are also supported here:

  • POSTGRES_PASSWORD
  • POSTGRES_USER
  • POSTGRES_DB
  • POSTGRES_INITDB_ARGS
  • POSTGRES_INITDB_WALDIR
  • POSTGRES_HOST_AUTH_METHOD
  • PGDATA https://github.com/docker-library/docs/blob/master/postgres/README.md#pgdata

Read more in the https://github.com/docker-library/docs/blob/master/postgres/README.md

⚠️ PGDATA Volume Path Change

Starting from PostgreSQL 18, the default data directory (VOLUME) path has changed. This affects all corresponding postgis/postgis:18-* and newer images.

Summary of volume paths:

Image nameImage tag range--volume path
postgis/postgis18-*/var/lib/postgresql
postgis/postgis14-*17-*/var/lib/postgresql/data

Please adjust your volume mounts for 18+ images. For more details, see the https://github.com/docker-library/postgres/pull/1259.

Initialize Only on Empty Data Directory

Docker-specific environment variables (for example, POSTGRES_DB, POSTGRES_USER, POSTGRES_PASSWORD) take effect only when the container is started with an empty data directory. Any pre-existing database will be left untouched on container startup.

If you need to re-initialize or change settings, make sure to remove or re-create the volume first.

libpq Environment Variables

Please note that Docker environment variables are different from those used by the https://www.postgresql.org/docs/current/libpq-envars.html. These include: PGDATABASE, PGUSER, PGPASSWORD, and others used by client tools.

Troubleshooting tips

Troubleshooting can often be challenging. It's important to know that the docker-postgis repository is an extension of the official Docker PostgreSQL repository. Therefore, if you encounter any issues, it's worth testing whether the problem can be reproduced with the https://hub.docker.com/_/postgres. If so, it's recommended to search for solutions based on this. The following websites are suggested:

  • Upstream docker postgres repo: https://github.com/docker-library/postgres
    • search for the open or closed issues !
  • Docker Community Forums: https://forums.docker.com
  • Docker Community Slack: https://dockr.ly/slack
  • Stack Overflow: https://stackoverflow.com/questions/tagged/docker+postgresql

If your problem is PostGIS related:

  • Stack Overflow : docker + postgis https://stackoverflow.com/questions/tagged/docker+postgis
  • PostGIS issue tracker: https://trac.osgeo.org/postgis/report

And if you don't have a postgres docker experience - read this blog post:

  • https://www.docker.com/blog/how-to-use-the-postgres-docker-official-image/

Security

It's crucial to be aware that in a cloud environment, with default settings, these images are vulnerable, and there's a high risk of ***miner infection if the ports are left open. ( https://github.com/docker-library/postgres/issues/770#issuecomment-704460980 )

  • Note that ports which are not bound to the host (i.e., -p 5432:5432 instead of -p 127.0.0.1:5432:5432) will be accessible from the outside. This also applies if you configured UFW to block this specific port, as Docker manages its own iptables rules. ( https://docs.docker.com/network/iptables/ )

io_uring

Every postgis/postgis:18-* image includes io_uring capabilities for asynchronous I/O. However, some container runtimes (for example, https://github.com/containerd/containerd/issues/9048) have disabled io_uring support in the past due to security concerns. If you wish to experiment with this feature, please do so at your own risk, and only after explicitly enabling io_uring in your https://docs.docker.com/engine/security/seccomp/.

Recommendations

  • You can add options for using SSL ( https://github.com/docker-library/postgres/issues/989#issuecomment-*** )
    • -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key
  • Or you can use https://www.postgresql.org/docs/15/ssh-tunnels.html with -p 127.0.0.1:5432:5432

Security scanner information

  • Please also scan the base postgres Docker image for potential security issues. If your security scanner reports vulnerabilities (CVEs), check the https://github.com/docker-library/faq#why-does-my-security-scanner-show-that-an-image-has-cves — especially the section “Why does my security scanner show that an image has CVEs?” For more specific issues related to the Postgres Docker image, you can search using these links:

    • https://github.com/search?q=repo%3Adocker-library%2Fpostgres+trivy&type=issues
    • https://github.com/search?q=repo%3Adocker-library%2Fpostgres+CVE&type=issues
  • Optimizing Security Scans: It's advisable to focus on scanning and fixing issues that can be resolved. Use this command to scan for fixable issues only:

    • trivy image --ignore-unfixed postgis/postgis:18-3.6-alpine
    • trivy image --ignore-unfixed postgres:18-alpine For more details, you can read this article

Limitations on Updates

Unfortunately, we don't have control over updates to Debian and Alpine distributions or the upstream postgres image. Because of this, there might be some issues that we cannot fix right away. On the positive side, the postgis/postgis images are regenerated every Monday. This process is to ensure they include the latest changes and improvements. As a result, these images are consistently kept up-to-date.

Suggestions Welcome

We are always open to suggestions to enhance security. If you have any ideas, please let us know.

Known Issues / Errors

When you encounter errors due to PostGIS update OperationalError: could not access file "$libdir/postgis-X.X, run:

docker exec some-postgis update-postgis.sh

It will update to your newest PostGIS. Update is idempotent, so it won't hurt when you run it more than once. You will get a notification like:

log
Updating PostGIS extensions template_postgis to X.X.X
NOTICE:  version "X.X.X" of extension "postgis" is already installed
NOTICE:  version "X.X.X" of extension "postgis_topology" is already installed
NOTICE:  version "X.X.X" of extension "postgis_tiger_geocoder" is already installed
ALTER EXTENSION
Updating PostGIS extensions docker to X.X.X
NOTICE:  version "X.X.X" of extension "postgis" is already installed
NOTICE:  version "X.X.X" of extension "postgis_topology" is already installed
NOTICE:  version "X.X.X" of extension "postgis_tiger_geocoder" is already installed
ALTER EXTENSION

Contributor guideline

This Docker-PostGIS project https://postgis.net/development/rfcs/rfc05/#projects-under-postgis-umbrella and follows more flexible contributor rules.

  • Please take a moment to review the current issues, discussions, and pull requests before you start.
  • If you have a major change in mind, we kindly ask you to start a discussion about it first.
  • After making changes to the templates, please run the ./update.sh script.
  • The README.md must be written in plain and platform-compatible Markdown that renders correctly on both GitHub and https://hub.docker.com/r/postgis/postgis.

Code of Conduct

Link to https://postgis.net/community/conduct/

更多相关 Docker 镜像与资源

以下是 postgis/postgis 相关的常用 Docker 镜像,适用于 不同场景 等不同场景:

  • kartoza/postgis Docker 镜像说明(PostGIS 地理空间数据库扩展,基于 PostgreSQL)
  • imresamu/postgis Docker 镜像说明(PostGIS 地理空间数据库扩展,Imresamu 维护版本)
  • corpusops/postgis Docker 镜像说明(Postgis 镜像变体,适合 Postgis、Postgres、Postgresql 相关部署场景)
  • library/postgres Docker 镜像说明
  • cimg/postgres Docker 镜像说明(CI/CD 优化版本)

镜像拉取方式

您可以使用以下命令拉取该镜像。请将 <标签> 替换为具体的标签版本。如需查看所有可用标签版本,请访问 标签列表页面

轩辕镜像加速拉取命令点我查看更多 postgis 镜像标签

docker pull docker.xuanyuan.run/postgis/postgis:<标签>

DockerHub 原生拉取命令

docker pull postgis/postgis:<标签>

用户好评

来自真实用户的反馈,见证轩辕镜像的优质服务

用户头像

oldzhang

运维工程师

Linux服务器

5

"Docker访问体验非常流畅,大镜像也能快速完成下载。"

专业版 · 高速稳定拉取镜像
50GB 仅 ¥8/年
高速镜像下载在线技术支持99.95% SLA 保障付费会员免广告