开发者

PostgreSQL: non-GUI monitoring

开发者 https://www.devze.com 2023-01-28 06:37 出处:网络
I\'ve read a lot about PostgreSQL monitoring through GUI tools but that doesn\'t match our modus operandi: shell or Perl scripts tied to SCCS for change-control/auditing, run via cron or interactively

I've read a lot about PostgreSQL monitoring through GUI tools but that doesn't match our modus operandi: shell or Perl scripts tied to SCCS for change-control/auditing, run via cron or interactively. We tend to prefer the command line over point-and-click.

The closest I've found is pg_top, which I'm working on installing (grumble grumble), and check_postgres.pl, which is a back-end to data collection for Nagios and MRTG. Although the graph presentation is pretty, it's no开发者_如何学Pythont our approach... but the Perl itself appears quite useful (so far).

Are there other non-GUI tools out there I may be missing? Although I could write what's needed, I'd hate to reinvent wheels.

Thanks.


Did you have a look at the built-in monitoring views?

http://www.postgresql.org/docs/current/static/monitoring-stats.html
http://www.varlena.com/GeneralBits/107.php

Edit:

There is also pgStatspack for performance monitoring:
http://pgfoundry.org/forum/forum.php?forum_id=1758

0

精彩评论

暂无评论...
验证码 换一张
取 消