Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being monitored ... ?

2006-07-10 Thread hubert depesz lubaczewski
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

Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being monitored ... ?

2006-07-07 Thread hubert depesz lubaczewski
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

Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being monitored ... ?

2006-07-06 Thread ogjunk-pgjedan
: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

Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being monitored ... ?

2006-06-11 Thread hubert depesz lubaczewski
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

[ADMIN] How are ppl monitoring PostgreSQL ... ? What is being monitored ... ?

2006-06-10 Thread Marc G. Fournier
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