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 wh
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 a
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 c
: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 switche
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 (htt
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 v
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
[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 go
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 r
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 kno
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
12 matches
Mail list logo