oracle PostgreSQL 管理和监控
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/556325/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
PostgreSQL management and monitoring
提问by Jacob
Moving from Oracle to PostgreSQL, what (preferably free/OSS) software/tools are available that replace Oracle Enterprise Manager? I'm aware of pgAdmin, as well as some tools bundled into EnterpriseDB's Postgres Plus AS, but am looking for more context and a better overview of the PostgreSQL ecosystem.
从 Oracle 迁移到 PostgreSQL，有哪些（最好是免费/OSS）软件/工具可以替代 Oracle Enterprise Manager？我知道 pgAdmin，以及一些捆绑在 EnterpriseDB 的 Postgres Plus AS 中的工具，但我正在寻找更多的上下文和对 PostgreSQL 生态系统的更好的概述。
Specifically I'm interested in tools to help:
具体来说，我对提供帮助的工具感兴趣：
- Alert db administrators to problems with both configuration and performance
- Monitoring of overall system performance
- General performance tuning
- Hinting support (my understanding is that PostgreSQL typically frowns on hinting)
- Disk management (ease in growth)
- Backup/restore beyond pg_dump and pg_restore
- 提醒数据库管理员注意配置和性能方面的问题
- 监控整体系统性能
- 一般性能调优
- 提示支持（我的理解是 PostgreSQL 通常不喜欢提示）
- 磁盘管理（易于增长）
- pg_dump 和 pg_restore 之外的备份/恢复
Any thoughts? This seems like something lots of folks may have been through before.
有什么想法吗？这似乎是很多人以前可能经历过的事情。
回答by caseman
Postgres comes with excellent command-line tools, and they're the focus of the core developer team. I personally leverage those via custom site-specific scripts for db admin, upgrade, replication. For monitoring I use nagios to script psql to query vitals.
Postgres 带有优秀的命令行工具，它们是核心开发团队的重点。我个人通过自定义站点特定脚本来利用这些脚本进行数据库管理、升级、复制。为了监控，我使用 nagios 编写 psql 脚本来查询生命体征。
That said, there are some other options on the GUI-side beyond pgAdmin:
也就是说，除了 pgAdmin 之外，GUI 端还有一些其他选项：
I don't think any of these have all of the features you listed, but they might be a good jumping off point. I doubt you will find an open source tool that really competes head-to-head with Oracle Enterprise Manager. On the commercial-side, there are also additional options:
我认为其中任何一个都没有您列出的所有功能，但它们可能是一个很好的起点。我怀疑您会找到真正与 Oracle Enterprise Manager 正面竞争的开源工具。在商业方面，还有其他选择：
This wiki page also has links to many other postgres tools:
这个 wiki 页面也有许多其他 postgres 工具的链接：
Community Guide to PostgreSQL GUI Tools
Being a CLI-zealot myself I cannot given any specific recommendations but hopefully this is helpful.
作为一个 CLI 狂热者，我无法给出任何具体的建议，但希望这会有所帮助。
回答by Michael Renner
From the management tool perspective caseman has already compiled a nice list, the PostgreSQL wiki also has a few additional ones on their GUI Database Design Toolspage.
从管理工具的角度来看，caseman 已经编制了一个不错的列表，PostgreSQL wiki 在他们的GUI 数据库设计工具页面上还有一些其他的。
For Monitoring/Tuning it's a bit more complicated, there are many tools but no thorough solution. I started compiling a list, again in the Postgres Wiki: Monitoring tools.
对于监控/调整，它有点复杂，有很多工具但没有彻底的解决方案。我再次在 Postgres Wiki: Monitoring tools 中开始编译一个列表。
Being unhappy with the status quo I teamed up with a colleague and we started working on our own solution called pganalyze, trying to help (parttime-)DBAs to understand what's going on in the database. But we also can only focus on a small subset of the problem area for the time being...
由于对现状不满意，我与一位同事合作，我们开始研究我们自己的解决方案，称为pganalyze，试图帮助（兼职）DBA 了解数据库中发生的事情。但我们暂时也只能关注问题区域的一小部分......
回答by Lennart Koopmann
I think the best site to search for software that fits your need would be PgFoundry: http://pgfoundry.org/
我认为搜索适合您需要的软件的最佳站点是 PgFoundry：http://pgfoundry.org/
I don't think there is a software that fits all your needs but maybe you can combine some tools to get what you want.
我不认为有一款软件可以满足您的所有需求，但也许您可以结合一些工具来获得您想要的。
回答by Lennart Koopmann
I have been using some free gui tools but none of it can compare with Navicat PostgreSQL GUI. I think it's the Cat Pajamas!
我一直在使用一些免费的 gui 工具，但没有一个可以与 Navicat PostgreSQL GUI 相提并论。我认为是猫睡衣！
they've a free version now, http://www.navicat.com.
他们现在有免费版本，http://www.navicat.com。
martinlee
马丁利
