导读
pgAdmin是最先进的开源数据库管理和开发平台,支持PostgreSQL和EDB Advanced Server,功能丰富,跨平台,是最受欢迎的选择。
介绍
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 7.6¶
Release date: 2023-08-24
This release contains a number of bug fixes and new features since the release of pgAdmin 4 v7.5.
Supported Database Servers¶
PostgreSQL: 11, 12, 13, 14 and 15
EDB Advanced Server: 11, 12, 13, 14 and 15
Bundled PostgreSQL Utilities¶
psql, pg_dump, pg_dumpall, pg_restore: 15.3
New features¶
Issue #2595 – Added Expression to CREATE INDEX.
Issue #3942 – Added cascade option while creating an extension.
Issue #5759 – Added ‘Ignore Grants’ option in the schema diff tool.
Issue #6004 – Added ‘Ignore Tablespace’ option in the schema diff tool.
Issue #6375 – Added support for ALTER INDEX column statistics.
Issue #6376 – Added unlogged option while creating a sequence.
Issue #6377 – Added all like options while creating a table.
Issue #6381 – Added support for SYSTEM, CONCURRENTLY and TABLESPACE options in REINDEX.
Issue #6382 – Added WAL option to EXPLAIN ANALYZE command.
Issue #6397 – Added new/missing options to the VACUUM command.
Issue #6415 – Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command.
Issue #6448 – Add support for TRUNCATE trigger in foreign table.
Issue #6595 – Ensure that Schema Diff comparison results should be displayed in the sorted order.
Housekeeping¶
Issue #3702 – Generate software bill of materials as part of the package builds.
Issue #6588 – Added support for PostgreSQL and EPAS 16 to ensure it works without any errors.
Bug fixes¶
Issue #5454 – Fix incorrect redirection URL after authentication by removing fixed value set to SCRIPT_NAME environment variable in pgAdmin4.wsgi file.
Issue #6208 – Allow changing the POOL_SIZE and MAX_OVERFLOW config values of the pgAdmin config DB connection pool.
Issue #6252 – Fix an issue where query tool on shared server is throwing error if the pgAdmin config DB is external.
Issue #6420 – Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live.
Issue #6500 – Fix the issue where query tool window turns blank if the user tries to generate a graph on the result.
Issue #6624 – Fix an issue where changing MFA_SUPPORTED_METHODS breaks the MFA validation.
Issue #6630 – Fix an issue where pgAdmin 7.5 fails to render table SQL with extension loaded index method.
Issue #6639 – Fix an issue where cycle syntax was not added in SQL when creating new sequence from UI.
Issue #6651 – Fix an issue where the SET directive is excluded from the function header in the schema diff tool.
Issue #6660 – Fix a query tool error ‘pgAdminThread’ object has no attribute ‘native_id’.
Issue #6664 – Ensure keyboard shortcut for query execution is disabled when query execution is in progress.
评论0