ubuntu/postgres Docker 镜像 - 轩辕镜像
ubuntu/postgresPostgreSQL是一款开源的对象关系型数据库，它功能强大、稳定性高，广泛应用于各类企业级应用和数据管理场景，支持复杂查询、事务处理及高级数据类型，其长期版本由Canonical负责维护，为用户提供持续的技术支持与更新服务，确保数据库系统在长期使用中的可靠性与安全性，是全球众多开发者和企业信赖的主流数据库解决方案之一。
42 收藏0 次下载activeubuntu镜像
Postgres | Ubuntu
Current Postgres Docker Image from Canonical, based on Ubuntu. Receives security updates and rolls to newer Postgres or Ubuntu release. This repository is free to use and exempted from per-user rate limits.
About Postgres
PostgreSQL is a powerful, open source object-relational database system. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation. Read more on the PostgreSQL website.
Tags and Architectures
!LTS Up to 5 years of free security maintenance on LTS channels.
!ESM Up to 10 years of customer security maintenance from Canonical's restricted repositories.
| Channel Tags | Supported until | Currently | Architectures |
|---|---|---|---|
14-22.04_beta | 04/2027 | Postgres 14 on Ubuntu 22.04 LTS | amd64, arm64, ppc64el, s390x |
12-20.04_beta | 04/2025 | Postgres 12.4 on Ubuntu 20.04 LTS | amd64, arm64, ppc64el, s390x |
track_risk |
Channel Tags shows the most stable channel for that track ordered stable, candidate, beta, edge. More risky channels are always implicitly available. So if beta is listed, you can also pull edge. If candidate is listed, you can pull beta and edge. When stable is listed, all four are available. Images are guaranteed to progress through the sequence edge, beta, candidate before stable.
Commercial use and Extended Security Maintenance channels
If your usage includes commercial redistribution, or requires ESM or unavailable channels/versions, please get in touch with the Canonical team (or using ***).
Usage
Launch this image locally:
shdocker run -d --name postgres-container -e TZ=UTC -p 30432:5432 -e POSTGRES_PASSWORD=My:s3Cr3t/ ubuntu/postgres:14-22.04_beta
Access your PostgreSQL server at localhost:30432.
Parameters
| Parameter | Description |
|---|---|
-e TZ=UTC | Timezone. |
-e POSTGRES_PASSWORD=secret | Set the password for the superuser which is postgres by default. Bear in mind that to connect to the database in the same host the password is not needed but to access it via an external host (for instance another container) the password is needed. This option is mandatory and must not be empty. |
-e POSTGRES_USER=john | Create a new user with superuser privileges. This is used in conjunction with POSTGRES_PASSWORD. |
-e POSTGRES_DB=db_test | Set the name of the default database. |
-e POSTGRES_INITDB_ARGS="--data-checksums" | Pass arguments to the postgres initdb call. |
-e POSTGRES_INITDB_WALDIR=/path/to/location | Set the location of the Postgres transaction log. By default it is stored in a subdirectory of the main Postgres data folder (PGDATA). |
-e POSTGRES_HOST_AUTH_METHOD=trust | Set the auth-method for host connections for all databases, all users, and all addresses. The following will be added to the pg_hba.conf if this option is passed: host all all all $POSTGRES_HOST_AUTH_METHOD. |
-e PGDATA=/path/to/location | Set the location of the database files. The default is /var/lib/postgresql/data. |
-p 30432:5432 | Expose Postgres on localhost:30432. |
-v /path/to/postgresql.conf:/etc/postgresql/postgresql.conf | Local configuration file postgresql.conf (try this example). |
-v /path/to/persisted/data:/var/lib/postgresql/data | Persist data instead of initializing a new database every time you launch a new container. |
Initialization Scripts
One can also add initialization scripts to their containers. This includes *.sql, .sql.gz, and *.sh scripts, and you just need to put them inside the /docker-entrypoint-initdb.d directory inside the container. After Postgres initialization is done and the default database and user are created, the scripts are executed in the following order:
- Run any
*.sqlfiles in alphabetically order. It will be executed withPOSTGRES_USER. - Run any executable
*.shscripts in alphabetically order. - Source any non-executable
*.shscripts in alphabetically order.
All of this is done before the Postgres service is started. Keep in mind if your PGDATA directory is not empty (contains pre-existing database) they will be left untouched.
Testing/Debugging
To debug the container:
shdocker logs -f postgres-container
To get an interactive shell:
shdocker exec -it postgres-container /bin/bash
This image also includes the psql client for interactive container use:
sh$ docker network create postgres-network $ docker network connect postgres-network postgres-container $ docker run -it --rm --network postgres-network ubuntu/postgres:14-22.04_beta psql -h postgres-container -U postgres
The password will be asked and you can enter My:s3Cr3t/. Now, you are logged in and can enjoy your new instance.
Deploy with Kubernetes
Works with any Kubernetes; if you don't have one, we recommend you install MicroK8s and microk8s.enable dns storage then snap alias microk8s.kubectl kubectl.
Download
postgresql.conf and
postgres-deployment.yml and set containers.postgres.image in postgres-deployment.yml to your chosen channel tag (e.g. ubuntu/postgres:14-22.04_beta), then:
shkubectl create configmap postgres-config --from-file=main-config=postgresql.conf kubectl apply -f postgres-deployment.yml
You will now be able to connect to the Postgres server on localhost:30306.
Bugs and feature requests
If you find a bug in our image or want to request a specific feature, please file a bug here:
[***]
Please title the bug "postgres: <issue summary>". Make sure to include the digest of the image you are using, from:
shdocker images --no-trunc --quiet ubuntu/postgres:<tag>
Deprecated channels & tags
These channels (tags) are not updated anymore. Please upgrade to newer channels, or reach out if you can't upgrade.
| Track | Version | EOL | Upgrade Path |
|---|---|---|---|
| Postgres 13.1 on Ubuntu 21.10 | 07/2022 | | |
| Postgres 13.1 on Ubuntu 21.04 | 01/2022 | | |
track |
postgres
by library
官方
PostgreSQL作为一款功能强大的对象关系型数据库系统，凭借其先进的架构设计与完善的技术机制，不仅能高效融合关系型数据的结构化管理与对象型数据的灵活扩展，更通过严格的ACID事务支持、多版本并发控制及全面的数据校验机制，为各类应用场景提供卓越的系统可靠性与极致的数据完整性保障，是全球广泛应用的开源数据库优选方案。
147301B+ pulls
上次更新：8 天前
cimg/postgres
by CircleCI
认证
CircleCI便捷镜像，集成PostgreSQL数据库，用于CI/CD流程中快速部署和运行PostgreSQL相关的测试及开发任务，简化配置。
7500M+ pulls
上次更新：3 个月前
kasmweb/postgres
by Kasm Technologies
认证
Kasm Technologies维护的Postgres镜像，包含pg_audit及其他修改。
6100K+ pulls
上次更新：4 天前
elestio/postgres
by Elestio
认证
Elestio验证和打包的PostgreSQL镜像，提供高级对象关系型数据库管理系统，支持SQL标准扩展子集（事务、外键、子查询等），确保与原始源同步更新、及时获取最新修复和功能，并经过质量控制检查，适合可靠的数据库部署需求。
2100K+ pulls
上次更新：1 个月前
mcp/postgres
by mcp
认证
提供PostgreSQL数据库的只读访问，使LLMs能够检查数据库的服务器。
33100K+ pulls
上次更新：6 个月前
chainguard/postgres
by Chainguard, Inc.
认证
使用Chainguard的低至零CVE容器镜像构建、发布和运行安全软件。
150K+ pulls
上次更新：5 天前
轩辕镜像配置手册
探索更多轩辕镜像的使用方法，找到最适合您系统的配置方式
登录仓库拉取
通过 Docker 登录认证访问私有仓库
Linux
在 Linux 系统配置镜像服务
Windows/Mac
在 Docker Desktop 配置镜像
Docker Compose
Docker Compose 项目配置
K8s Containerd
Kubernetes 集群配置 Containerd
K3s
K3s 轻量级 Kubernetes 镜像加速
宝塔面板
在宝塔面板一键配置镜像
群晖
Synology 群晖 NAS 配置
飞牛
飞牛 fnOS 系统配置镜像
极空间
极空间 NAS 系统配置服务
爱快路由
爱快 iKuai 路由系统配置
绿联
绿联 NAS 系统配置镜像
威联通
QNAP 威联通 NAS 配置
Podman
Podman 容器引擎配置
Singularity/Apptainer
HPC 科学计算容器配置
其他仓库配置
ghcr、Quay、nvcr 等镜像仓库
专属域名拉取
无需登录使用专属域名
需要其他帮助？请查看我们的 常见问题Docker 镜像访问常见问题解答 或 提交工单
镜像拉取常见问题
轩辕镜像免费版与专业版有什么区别？
免费版仅支持 Docker Hub 访问，不承诺可用性和速度；专业版支持更多镜像源，保证可用性和稳定速度，提供优先客服响应。
轩辕镜像支持哪些镜像仓库？
专业版支持 docker.io、gcr.io、ghcr.io、registry.k8s.io、nvcr.io、quay.io、mcr.microsoft.com、docker.elastic.co 等；免费版仅支持 docker.io。
流量耗尽错误提示
当返回 402 Payment Required 错误时，表示流量已耗尽，需要充值流量包以恢复服务。
410 错误问题
通常由 Docker 版本过低导致，需要升级到 20.x 或更高版本以支持 V2 协议。
manifest unknown 错误
先检查 Docker 版本，版本过低则升级；版本正常则验证镜像信息是否正确。
镜像拉取成功后，如何去掉轩辕镜像域名前缀？
使用 docker tag 命令为镜像打上新标签，去掉域名前缀，使镜像名称更简洁。
用户好评
来自真实用户的反馈，见证轩辕镜像的优质服务
oldzhang
运维工程师
Linux服务器
5
"Docker访问体验非常流畅，大镜像也能快速完成下载。"