On 7/9/06, Jeff Frost [EMAIL PROTECTED] wrote:
Do you already have a MRTG plugin for postgres that you've written and if so,care to share it with the rest of us?Or better yet, share it with themrtg.org folks?I was thinking of writing one, but if you have one already, I
hate to reinvent the
On Fri, 7 Jul 2006, hubert depesz lubaczewski wrote:
periodically (every 5 minutes) i do:
select sum(xact_commit) + sum(xact_rollback) from pg_stat_database
and then just check against previous value, and calculate per/second. this
is actually handled nicely by mrtg itself.
Hubert,
Do you
On 7/7/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Interesting, Hubert.Where/how do you get the data for:- number of transactions per second
periodically (every 5 minutes) i do:select sum(xact_commit) + sum(xact_rollback) from pg_stat_databaseand then just check against previous value, and
:20 AM
Subject: Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being
monitored ... ?
On 6/10/06, Marc G. Fournier wrote: The subject kinda says it all ... I know
there are SNMP patches available
out there now, but without those ... ?
i can tell you what we do monitor:
1
On 6/10/06, Marc G. Fournier [EMAIL PROTECTED] wrote:
The subject kinda says it all ... I know there are SNMP patches availableout there now, but without those ... ?i can tell you what we do monitor:1. general server things (free disk space, cpu-idle, load, memory used, swap used, context
The subject kinda says it all ... I know there are SNMP patches available
out there now, but without those ... ?
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . [EMAIL PROTECTED] MSN . [EMAIL PROTECTED]
Yahoo . yscrappy
I'm using a great little Linux program called monit to check that
there's something listening on the 5432 port. It also monitors
individual process memory and CPU usage etc. Quite good.
http://www.tildeslash.com/monit/
Andy
Marc G. Fournier wrote:
The subject kinda says it all ... I know
On Sat, Jun 10, 2006 at 07:29:52PM +0100, Andy Shellam wrote:
I'm using a great little Linux program called monit to check that
there's something listening on the 5432 port. It also monitors
individual process memory and CPU usage etc. Quite good.
A server can be quite broken yet still
[EMAIL PROTECTED] (Michael Fuhr) wrote:
On Sat, Jun 10, 2006 at 07:29:52PM +0100, Andy Shellam wrote:
I'm using a great little Linux program called monit to check that
there's something listening on the 5432 port. It also monitors
individual process memory and CPU usage etc. Quite good.
A
Marc G. Fournier wrote:
The subject kinda says it all ... I know there are SNMP patches
available out there now, but without those ... ?
We use Nagios to call shell scripts that perform specific requests to a
PostgreSQL server. Usually over SSH via psql, but you could use anything.
Joshua
On Sat, 10 Jun 2006, Joshua D. Drake wrote:
Marc G. Fournier wrote:
The subject kinda says it all ... I know there are SNMP patches available
out there now, but without those ... ?
We use Nagios to call shell scripts that perform specific requests to a
PostgreSQL server. Usually over SSH
SELECT count(1) FROM pg_connections;
would be a good one to graph ...
Well you should use pg_stat_databases for that :)
We have complete graphing and monitoring service coming out at the end
of this month.
Joshua D. Drake
Marc G. Fournier Hub.Org Networking Services
12 matches
Mail list logo