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
更新日志
Nov 14, 2024
Supported Database Servers:
PostgreSQL: 12, 13, 14, 15, 16 and 17
EDB Advanced Server: 12, 13, 14, 15, and 16
Bundled PostgreSQL Utilities:
psql, pg_dump, pg_dumpall, pg_restore: 17.0
New features:
Issue #1780 – Replace infinite scrolling with pagination in query tool data output for better UX and performance.
Issue #1984 – Add an object menu option to disconnect all server and database connections.
Issue #2874 – Alternate the background color of rows to enhance readability.
Issue #5869 – Allow to pass PGADMIN_CONFIG_CONFIG_DATABASE_URI from docker secrets.
Issue #6016 – Format dashboard graph metrics for better readability.
Issue #7393 – Added support for auto-detecting and setting the End-of-line character (LF/CRLF) in the query tool editor.
Issue #7863 – Make the background color for the serial number and header cells distinct.
Housekeeping:
Issue #8061 – Updated the react-menu library from v2 to v4.
Issue #8077 – Remove bootstrap from the runtime code.
Issue #8102 – Remove the dependency on python packages eventlet and greenlet.
Bug fixes:
Issue #5307 – Fixed an issue to allow the Enter key to save data in the result grid text editor.
Issue #7289 – Move ‘About pgAdmin 4’ to app menu on macOS.
Issue #7655 – Fixed an issue where the query tool was crashing when an empty geometry was being rendered.
Issue #7837 – Fixed an issue where role properties were not loading.
Issue #7883 – Fix multiple issues related to debugger params dialog input.
Issue #7919 – Fixed an issue where the dock layout was not saved upon closing a tab.
Issue #7920 – Fixed an issue where the copy shortcut CTRL +C was not working in the Query Tool data grid.
Issue #7955 – Fixed an issue where Dashboard tab showing ‘Something went wrong’.
Issue #7957 – Fixed an issue where cursor selection is not visible in the PSQL tool.
Issue #7965 – Allow OAuth2 params OAUTH2_NAME, OAUTH2_DISPLAY_NAME, OAUTH2_ICON, OAUTH2_BUTTON_COLOR to be optional.
Issue #7988 – Add appropriate minimum width and height setting for desktop apps to avoid app accidentally going below visibility levels.
Issue #7993 – Fixed an issue where graphical explain keeps the node details open even after plan changed.
Issue #8007 – Fixed an issue in the debugger where function arguments of the character data type were being truncated.
Issue #8013 – Fix the issue where rows do not retain shading when scrolling.
Issue #8022 – Use PG17 as the default in the container.
