Puresys纯净系统-软件下载介绍
pgAdmin 是世界上最先进的开源数据库 PostgreSQL 最流行、功能最丰富的开源管理和开发平台。pgAdmin 可用于 Linux、Unix、macOS 和 Windows 来管理 PostgreSQL 和 EDB Advanced Server 9.5 及更高版本。
软件截图
软件特点
pgAdmin 具有大量功能，到目前为止，查看所有功能的最佳方式是下载副本并尝试一下。这是一个简短的列表，可让您了解其功能：
多平台
- Microsoft Windows ™
- Linux
- macOS
专为多个 PostgreSQL 版本和衍生产品而设计
pgAdmin 支持在发布任何给定版本 pgAdmin 时支持的 PostgreSQL 和 EDB Postgres Advanced Server 版本。
广泛的文档
pgAdmin 应用程序文档
PostgreSQL 文档链接
多种部署模式
桌面模式，使用专门构建的运行时
服务器模式，支持网络多用户
工具
具有颜色语法高亮功能的强大查询工具
用于显示/输入数据的快速数据网格
图形查询计划展示
用于快速更新 ACL 的授予向导
过程语言调试器（支持 pl/pgsql 和 edb-spl）
模式差异工具，用于管理模式之间的差异
用于设计和记录模式的 ERD 工具
日常维护
自动管理
监控仪表板
按需备份、恢复、清理和分析
SQL/shell/批处理作业调度代理
创建、查看和编辑所有常见的 PostgreSQL 对象
对象与其 SQL 定义以及用户友好的属性列表一起显示。还可以浏览从属对象和从属对象，并在适当的情况下查看对象统计信息。
列
约束
数据库
域
外部表
国外服务器
外部数据包装器
FTS 配置
FTS词典
FTS 解析器
FTS 模板
索引
语言
物化视图
规则
程序语言
模式
序列
表
表空间
触发功能
类型
观看次数
EDB Postgres Advanced Server 对象（例如包、过程和同义词）
pgAgent 对象（例如作业、调度）
多字节支持
pgAdmin 支持大多数 PostgreSQL 服务器端编码
SQL_ASCII
EUC_JP, EUC_CN, EUC_KR, EUC_TW
JOHAB
LATIN1, LATIN2, LATIN3, LATIN4, LATIN5, LATIN6, LATIN7, LATIN8, LATIN9, LATIN10
ISO_8859_5, ISO_8859_6, ISO_8859_7, ISO_8859_8
UNICODE/UTF-8
MULE_INTERNAL
KOI8
WIN
ALT
WIN1256
TCVN
WIN874
更新日志
pgAdmin 4 9.15
May 11, 2026
Supported Database Servers:
PostgreSQL: 13, 14, 15, 16, 17 and 18
EDB Advanced Server: 13, 14, 15, 16, 17 and 18
Bundled PostgreSQL Utilities:
psql, pg_dump, pg_dumpall, pg_restore: 18.2
New features:
Issue #9657 – Allow the container image to run as a non-default user via the PUID and PGID environment variables.
Housekeeping:
Issue #9764 – Update the Swedish translation.
Issue #9827 – Bump Python and JavaScript dependencies.
Issue #9832 – Fix the Czech translation for ‘Refresh’.
Issue #9834 – Bump runtime dependencies and upgrade ESLint to v10.
Issue #9839 – Update the Russian translation.
Issue #9870 – Bump runtime and development dependencies.
Issue #9873 – Use an <OWNER> placeholder in resql tests instead of a hardcoded ‘postgres’ role to support non-default superuser names.
Issue #9893 – Update the Spanish translation.
Issue #9906 – Update the Italian translation.
Bug fixes:
Issue #9656 – Use absolute paths for a2enmod and a2enconf in the Debian setup script so it works when /usr/sbin is not on PATH.
Issue #9830 – Fix cross-user data access and shared-server privilege escalation in server mode (CVE-2026-7813). Also applies the @with_object_filters access-control decorator to ServerNode.list.
Issue #9835 – Tighten Shared Server feature parity, owner-only field handling, and write guards as a follow-up to the data-isolation hardening.
Issue #9865 – Fix stored cross-site scripting (XSS) via crafted PostgreSQL object names rendered in the Browser Tree and Explain Visualizer (CVE-2026-7814). Reported by Fahar Abbas.
Issue #9898 – Fix SQL injection in Maintenance tool option values (CVE-2026-7815). Reported by j3seer.
Issue #9899 – Fix OS command injection in Import/Export query export (CVE-2026-7816). Reported by Chung Kim (chungkn), OneMount Group.
Issue #9900 – Fix local-file inclusion and server-side request forgery in LLM API configuration endpoints (CVE-2026-7817). Reported by j3seer.
Issue #9901 – Fix unsafe deserialization in the session manager that could lead to remote code execution (CVE-2026-7818). Also encrypts session files at rest using Fernet, restricts session-file permissions to 0o600, switches the session-digest default from SHA-1 to SHA-256, drops several non-roundtrippable live objects from the session (AuthSourceManager and the Azure, RDS, Google Cloud, and BigAnimal cloud-provider instances), tightens DATA_DIR file and directory permissions at creation, creates pgadmin4.log with mode 0o600, hardens EnhancedRotatingFileHandler._open against rotation failures, and bounds the user_info_server prompt retry loop so a non-interactive caller cannot spin forever. Reported by Fernando Bortotti.
Issue #9902 – Fix symlink-based path traversal in the file manager (CVE-2026-7819). Reported by Fernando Bortotti.
Issue #9904 – Fix account-lockout bypass on Flask-Security’s default /login view by overriding User.is_active and User.is_locked() so the locked field is honored on every authentication path (CVE-2026-7820). Reported by Fernando Bortotti.
Additional changes (no associated issue):
The commits below did not have a dedicated GitHub issue. They are listed here for transparency.
Bug fixes:
1518b0828 – Restore the SERVER_MODE python-test path and fix two endpoint regressions surfaced by it.
d57acce35 – Harden validation, preference, and connection-params paths against pre-existing edge cases.
Test-suite stability:
a11d289bd – Harden click_modal backdrop wait and open_query_tool stale-element retry in feature tests.
a50a553b0 – Feature tests use sys.executable; sync yarn.lock to package.json.
0fad04de8 – PSQL socket tests use the authenticated tester; the role-dependencies test skips cleanly on auth failure.
1f7194924 – Harden six regression tests against environmental drift.
dc61039e9 – Quote the username in the views/mview test helper for dotted local roles.
9b29bc203 – Quote the username in the types/compound-triggers test helpers for dotted local roles.
504775de8 – Quote the username in the user-mappings test helper for dotted local roles.
208541cc4 – ImportExportServersTestCase uses sys.executable instead of a bare python and surfaces subprocess errors instead of swallowing them as a misleading JSON-parse failure.
Refactoring¶
6f4f28def – Factor the WTForms-error-to-JSON conversion into a helper and drop a dead import.
Documentation:
9923eefca – Clarify in login.rst and ldap.rst that MAX_LOGIN_ATTEMPTS applies only to the INTERNAL authentication source. Operators using LDAP, OAuth2, Kerberos, or Webserver auth should rely on the upstream identity provider’s lockout policy and reverse-proxy request rate-limiting.
Dependencies:
Non-breaking dependabot updates aggregated for v9.15.
Python:
boto3 1.42 -> 1.43 (python_version > ‘3.9’; Python 3.9 stays on 1.42)
cryptography 46.0 -> 47.0
psycopg 3.3.3 -> 3.3.4 (python_version >= ‘3.10’)
pycodestyle >=2.5.0 -> >=2.14.0
requests >=2.21.0 -> >=2.33.1
safety >=1.9.0 -> >=3.7.0
testtools 2.8.7 -> 2.9.1
typer 0.24 -> 0.25 (python > ‘3.9’)
JavaScript (web/):
@tanstack/react-query 5.90 -> 5.100.5
axios 1.15.2 -> 1.16.0
moment-timezone 0.6.0 -> 0.6.2
postcss 8.5.6 -> 8.5.12
JavaScript (runtime/):
axios 1.15.2 -> 1.16.0
electron 41.3.0 -> 41.5.0
eslint 10.2.1 -> 10.3.0
globals 17.5.0 -> 17.6.0
