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
更新日志
Version 9.2
Release date: 2025-04-03
This release contains a number of bug fixes and new features since the release of pgAdmin 4 v9.1.
Supported Database Servers¶
PostgreSQL: 13, 14, 15, 16 and 17
EDB Advanced Server: 13, 14, 15, 16 and 17
Bundled PostgreSQL Utilities¶
psql, pg_dump, pg_dumpall, pg_restore: 17.2
New features¶
Issue #0392 - Added an ability to configure the font family for SQL editors.
Issue #4194 - Added support to automatically open a file after it is downloaded in the desktop mode.
Issue #4503 - Added support for post-connection SQL execution, which will be run automatically on each connection made to any database of the server.
Issue #5871 - Add support for restoring plain SQL database dumps.
Issue #8034 - Added support for creating Directory nodes in EPAS.
Issue #8449 - Change icon buttons to show tooltip even when disabled.
Issue #8540 - Add an option to load/replace the servers.json file on each container startup.
Issue #8574 - Open user management in a separate tab instead of a dialog to enhance UI/UX.
Housekeeping¶
Issue #8545 - Added Security.md file.
Bug fixes¶
Issue #8316 - Ensure that modal dialogs are not triggered more than once to avoid duplicates.
Issue #8355 - Change session files garbage collection strategy.
Issue #8362 - Fixed an issue where pgAdmin should fallback to main screen if the last opened screen is disconnected.
Issue #8437 - Fixed an issue where the PSQL terminal displays keyname for non alphanumeric keys.
Issue #8462 - Fixed an issue where geometries in the geometry viewer will render partially when the container was resized.
Issue #8473 - Change the stop/terminate icon at all the places for better UX.
Issue #8479 - Fixed an issue where the Schema Diff was not displaying the difference query when a table had a UNIQUE NULLS NOT DISTINCT constraint.
Issue #8483 - Fixed an issue where the query tool data grid did not respect the default value for columns of domain type when the domain had a default value.
Issue #8514 - Ensure the newly added parameters in the server dialog are incorporated into the Import/Export Servers functionality.
Issue #8546 - Fixed an issue where updating the grantee was not correctly applying the privileges.
Issue #8577 - Fixed an issue where the upgrade_check API returned an unexpected keyword argument ‘cafile’ due to changes in the urllib package supporting Python v3.13.
Issue #8597 - Fixed an issue where delete/rename was done on wrong file after sorting in Storage Manager.
Issue #8602 - Fixed an XSS vulnerability issue in the Query Tool and View/Edit Data (CVE-2025-2946).
Issue #8603 - Fixed a remote code execution issue in the Query Tool and Cloud Deployment (CVE-2025-2945).
Issue #8623 - Fixed an issue where query tool is crashing on macOS 15.4 due to a locale issue.
