Do you guys have any suggestions on monitoring tools for postgresql
that would provide graphing of data & alerts ?
I have looked and tried out hyperic, munin, Nimbus but was hoping to
something better.

Thanks,

Marcelo
PostgreSQL DBA
Linux/Solaris System Administrator


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins <pglists [at] zeroaccess.org> wrote:

> Do you guys have any suggestions on monitoring tools for postgresql that
> would provide graphing of data & alerts ?
> I have looked and tried out hyperic, munin, Nimbus but was hoping to
> something better.

To monitor I use the following:

- pg_osmem: http://www.kennygorman.com/wordpress/?p=250
- pg_buffercache (contrib package in Debian)
- pg_top: http://ptop.projects.postgresql.org/
- ps
- pgd: http://www.kennygorman.com/wordpress/?p=260
- iotop: http://guichaz.free.fr/iotop/

And I am in the process of writing a bunch of scripts that the Zabbix
agent will execute to feed the server with information, so that alerts
and graphs can be produced.

--
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Marcelo Martins a =E9crit :
>
> Do you guys have any suggestions on monitoring tools for postgresql tha=
t
> would provide graphing of data & alerts ?
> I have looked and tried out hyperic, munin, Nimbus but was hoping to
> something better.

Note that you have some plugins :

* http://bucardo.org/check_postgres/ (plugin for nagios and others)
* http://muninpgplugins.projects.postgresql.org/ (for munin)


I prefer nagios+munin or nagios+other-graph_tool.

>
> Thanks,
>
> Marcelo
> PostgreSQL DBA
> Linux/Solaris System Administrator
>
>


- --
C=E9dric Villemain
Administrateur de Base de Donn=E9es
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkl0pdoACgkQo/dppWjpEvykagCdF0BlMSfyt92XM6NUj6Ez /Nl7
E4cAn2a0HVBgs33cKCoGW+uUSAuvtcg8
=3DMIMf
-----END PGP SIGNATURE-----

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

On Mon, Jan 19, 2009 at 05:10:07PM +0100, C=E9dric Villemain wrote:
> Note that you have some plugins :
>
> * http://bucardo.org/check_postgres/ (plugin for nagios and others)
> * http://muninpgplugins.projects.postgresql.org/ (for munin)
>

Thanks for these links. I am trying out the muninpgplugins but I get
"Global symbol "$statscope" requires explicit package name at /etc/munin/=
plugins//pg_exilog_stat_database line 179".
Execution of /etc/munin/plugins/pg_exilog_stat_database aborted due to co=
mpilation errors.


I have the following in /etc/munin/plugin-conf.d/munin-node

[pg_exilog*]
user postgres
env.dbhost localhost
env.dbname exilog
env.dbpass xxxxxxxxxx
env.dbuser exilog

Any idea why I get the error message?

Regards
Johann

--
Johann Spies Telefoon: 021-808 4036
Informasietegnologie, Universiteit van Stellenbosch

"Neither is there salvation in any other; for there is
none other name under heaven given among men, whereby
we must be saved." Acts 4:12

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--0016e640c6aa4592cf0460e8712d
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

RRD tool can used for drawing graphs by fetching the statics from DB
servers and plotting graphs store it an image file and embedded it on the
HTML page to look it nice .


2009/1/20 Johann Spies <jspies [at] sun.ac.za>

> On Mon, Jan 19, 2009 at 05:10:07PM +0100, C=E9dric Villemain wrote:
> > Note that you have some plugins :
> >
> > * http://bucardo.org/check_postgres/ (plugin for nagios and others)
> > * http://muninpgplugins.projects.postgresql.org/ (for munin)
> >
>
> Thanks for these links. I am trying out the muninpgplugins but I get
> "Global symbol "$statscope" requires explicit package name at
> /etc/munin/plugins//pg_exilog_stat_database line 179".
> Execution of /etc/munin/plugins/pg_exilog_stat_database aborted due to
> compilation errors.
>
>
> I have the following in /etc/munin/plugin-conf.d/munin-node
>
> [pg_exilog*]
> user postgres
> env.dbhost localhost
> env.dbname exilog
> env.dbpass xxxxxxxxxx
> env.dbuser exilog
>
> Any idea why I get the error message?
>
> Regards
> Johann
>
> --
> Johann Spies Telefoon: 021-808 4036
> Informasietegnologie, Universiteit van Stellenbosch
>
> "Neither is there salvation in any other; for there is
> none other name under heaven given among men, whereby
> we must be saved." Acts 4:12
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>



--
__________________________________________|
Regards,
Ashokraj
9940419867

--0016e640c6aa4592cf0460e8712d
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

 RRD tool can used for drawing graphs by fetching the statics from DB =
servers and plotting graphs store it an image file and embedded it on the H=
TML page to look it nice .<br>  <br><br><div class=3D"gmail_quote">200=
9/1/20 Johann Spies <span dir=3D"ltr"><<a href=3D"mailto:jspies [at] sun.ac.z=
a">jspies [at] sun.ac.za</a>></span><br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class=3D"Ih2=
E3d">On Mon, Jan 19, 2009 at 05:10:07PM +0100, C=E9dric Villemain wrote:<br=
>
> Note that you have some plugins :<br>
><br>
>  * <a href=3D"http://bucardo.org/check_postgres/" target=3D"_blan=
k">http://bucardo.org/check_postgres/</a> (plugin for nagios and others)<br=
>
>  * <a href=3D"http://muninpgplugins.projects.postgresql.org/" tar=
get=3D"_blank">http://muninpgplugins.projects.postgresql.org /</a> (for muni=
n)<br>
><br>
<br>
</div>Thanks for these links.  I am trying out the muninpgplugins but =
I get<br>
"Global symbol "$statscope" requires explicit package name a=
t /etc/munin/plugins//pg_exilog_stat_database line 179".<br>
Execution of /etc/munin/plugins/pg_exilog_stat_database aborted due to comp=
ilation errors.<br>
<br>
<br>
I have the following in /etc/munin/plugin-conf.d/munin-node<br>
<br>
[pg_exilog*]<br>
user postgres<br>
env.dbhost localhost<br>
env.dbname exilog<br>
env.dbpass xxxxxxxxxx<br>
env.dbuser exilog<br>
<br>
Any idea why I get the error message?<br>
<br>
Regards<br>
Johann<br>
<font color=3D"#888888"><br>
--<br>
Johann Spies          Telefoon: 021-808 4036<br>
Informasietegnologie, Universiteit van Stellenbosch<br>
<br>
    "Neither is there salvation in any other; for there is<=
br>
     none other name under heaven given among men, whereby<=
br>
     we must be saved."         &n=
bsp;     Acts 4:12<br>
</font><div><div></div><div class=3D"Wj3C7c"><br>
--<br>
Sent via pgsql-admin mailing list (<a href=3D"mailto:pgsql-admin [at] postgresql=
..org">pgsql-admin [at] postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-admin" target=3D"_blank=
">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
</div></div></blockquote></div><br><br clear=3D"all"><br>-- <br>___________=
_______________________________|<br>Regards,<br>Ashokraj<br>9940419867<br><=
br>

--0016e640c6aa4592cf0460e8712d--

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Johann Spies a =E9crit :
> On Mon, Jan 19, 2009 at 05:10:07PM +0100, C=E9dric Villemain wrote:
>> Note that you have some plugins :
>>
>> * http://bucardo.org/check_postgres/ (plugin for nagios and others)
>> * http://muninpgplugins.projects.postgresql.org/ (for munin)
>>
>
> Thanks for these links. I am trying out the muninpgplugins but I get
> "Global symbol "$statscope" requires explicit package name at /etc/muni=
n/plugins//pg_exilog_stat_database line 179".
> Execution of /etc/munin/plugins/pg_exilog_stat_database aborted due to =
compilation errors.
>
>
> I have the following in /etc/munin/plugin-conf.d/munin-node
>
> [pg_exilog*]
> user postgres
> env.dbhost localhost
> env.dbname exilog
> env.dbpass xxxxxxxxxx
> env.dbuser exilog
>
> Any idea why I get the error message?

Buggy script :-(

I will update the cvs and push a new version very soon.

>
> Regards
> Johann
>


- --
C=E9dric Villemain
Administrateur de Base de Donn=E9es
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkl1u0UACgkQo/dppWjpEvxizACfbfsB6kQ1HDK4LCnYG7wx BJgq
8HoAoKyCjKTjwB1trA32dtP+R2yhDy63
=3DiQa/
-----END PGP SIGNATURE-----

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Cool, I have actually been trying out Zabbiz 1.6.x now since I like it
better than munin.

Thanks,

Marcelo
PostgreSQL DBA
Linux/Solaris System Administrator

On Jan 19, 2009, at 9:56 AM, Jaume Sabater wrote:

> On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins <pglists [at] zeroaccess.org
> > wrote:
>
>> Do you guys have any suggestions on monitoring tools for postgresql
>> that
>> would provide graphing of data & alerts ?
>> I have looked and tried out hyperic, munin, Nimbus but was hoping to
>> something better.
>
> To monitor I use the following:
>
> - pg_osmem: http://www.kennygorman.com/wordpress/?p=250
> - pg_buffercache (contrib package in Debian)
> - pg_top: http://ptop.projects.postgresql.org/
> - ps
> - pgd: http://www.kennygorman.com/wordpress/?p=260
> - iotop: http://guichaz.free.fr/iotop/
>
> And I am in the process of writing a bunch of scripts that the Zabbix
> agent will execute to feed the server with information, so that alerts
> and graphs can be produced.
>
> --
> Jaume Sabater
> http://linuxsilo.net/
>
> "Ubi sapientas ibi libertas"


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--001517478a2e880c06046100f624
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

On Mon, Jan 19, 2009 at 6:56 PM, Jaume Sabater <jsabater [at] gmail.com> wrote:

> And I am in the process of writing a bunch of scripts that the Zabbix
> agent will execute to feed the server with information, so that alerts
> and graphs can be produced.


Oh, I have exactly the same in my plans. Where it would possible to download
them (if would)?

--
Vladimir Rusinov
http://greenmice.info/

--001517478a2e880c06046100f624
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<br><br> <br><br><div class=3D"gmail_quote">On Mon, Jan 19, 2009 at 6:56 PM=
, Jaume Sabater <span dir=3D"ltr"><<a href=3D"mailto:jsabater [at] gmail.com"=
>jsabater [at] gmail.com</a>></span> wrote:<br><blockquote class=3D"gmail_quo=
te" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt=
0.8ex; padding-left: 1ex;">
And I am in the process of writing a bunch of scripts that the Zabbix<br>
agent will execute to feed the server with information, so that alerts<br>
and graphs can be produced.</blockquote><br></div>Oh, I have exactly the sa=
me in my plans. Where it would possible to download them (if would)?<br cle=
ar=3D"all"><br>-- <br>Vladimir Rusinov<br><a href=3D"http://greenmice.info/=
">http://greenmice.info/</a><br>


--001517478a2e880c06046100f624--

On Wed, Jan 21, 2009 at 5:51 PM, Vladimir Rusinov
<vladimir [at] greenmice.info> wrote:

>> And I am in the process of writing a bunch of scripts that the Zabbix
>> agent will execute to feed the server with information, so that alerts
>> and graphs can be produced.
>
> Oh, I have exactly the same in my plans. Where it would possible to download
> them (if would)?

Of course you would but, honestly, it is not on top of my TODO list. I
will have to do them, eventually, but I don't see it happening in the
next 4 weeks. Feel free to get started with something and I'll
contribute with what I have as soon as I can (quite busy at work at
the moment, sorry). :)

--
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Vladimir Rusinov a =C3=A9crit :
> On Mon, Jan 19, 2009 at 6:56 PM, Jaume Sabater <jsabater [at] gmail.com> wro=
te:
>
>> And I am in the process of writing a bunch of scripts that the Zabbix
>> agent will execute to feed the server with information, so that alerts
>> and graphs can be produced.
>
>
> Oh, I have exactly the same in my plans. Where it would possible to dow=
nload
> them (if would)?
>

I did something in that way, check_postgres.pl is a good script to start =
from
(add a zabbix output perhaps). I stop working on that because zabbix is =
too
painfull to use (*for me*).

Here some draft note about zabbix+check_postgres...Hope it can help.

Agent side:

zabbix_agentd.conf :

UserParameter=3Dpgs[*],sudo -u postgres
/usr/local/share/zabbix/check_postgres.pl --output=3Dsimple --db=3D$2 --a=
ction=3D$1 $3
| head -n 1
UserParameter=3Dpgm[*],sudo -u postgres /usr/local/share/zabbix/check_pos=
tgres.pl
- --output=3Dmrtg --db=3D$2 --action=3D$1 $3 | head -n 1

sudoers :

Runas_Alias DB =3D postgres
User_Alias SUPERVISOR =3D zabbix
Cmnd_Alias CHECK_PG =3D /usr/local/share/zabbix/check_postgres.pl
SUPERVISOR ALL=3D(DB) NOPASSWD: CHECK_PG


init checksum :

sudo su -s /bin/bash - zabbix
sudo -u postgres /usr/local/share/zabbix/check_postgres.pl --db=3DDBNAME
- --action=3Dsettings_checksum --critical=3D0

Server side:

pgs :
check_postgres.pl output simple
pgs[ACTION,DBNAME]
pgm :
check_postgres.pl output mrtg
pgs[ACTION,DBNAME,EXTRA]


- --
C=C3=A9dric Villemain
Administrateur de Base de Donn=C3=A9es
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkl3XDgACgkQo/dppWjpEvz1LQCcDpd88zLVFSiFpqmA6Fr6 y7rF
LqMAn2z2SdI4BoceJf9elq72c1OytiHE
=3DJ5LP
-----END PGP SIGNATURE-----

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--0015174c0eca095f5604611603ad
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On Wed, Jan 21, 2009 at 8:32 PM, C=C3=A9dric Villemain <
cedric.villemain [at] dalibo.com> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Vladimir Rusinov a =C3=A9crit :
> > On Mon, Jan 19, 2009 at 6:56 PM, Jaume Sabater <jsabater [at] gmail.com>
> wrote:
> >
> >> And I am in the process of writing a bunch of scripts that the Zabbix
> >> agent will execute to feed the server with information, so that alerts
> >> and graphs can be produced.
> >
> >
> > Oh, I have exactly the same in my plans. Where it would possible to
> download
> > them (if would)?
> >
>
> I did something in that way, check_postgres.pl is a good script to start
> from
> (add a zabbix output perhaps). I stop working on that because zabbix is
> too
> painfull to use (*for me*).
>
> Here some draft note about zabbix+check_postgres...Hope it can help.


Thank you, it is good starting point, but I'm going to create template and
graphs for it, and it can take many time.

--
Vladimir Rusinov
http://greenmice.info/

--0015174c0eca095f5604611603ad
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<br><br><div class=3D"gmail_quote">On Wed, Jan 21, 2009 at 8:32 PM, C=C3=A9=
dric Villemain <span dir=3D"ltr"><<a href=3D"mailto:cedric.villemain [at] dal=
ibo.com">cedric.villemain [at] dalibo.com</a>></span> wrote:<br><blockquote c=
lass=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); ma=
rgin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class=3D"Ih2E3d">-----BEGIN PGP SIGNED MESSAGE-----<br>
Hash: SHA1<br>
<br>
</div>Vladimir Rusinov a =C3=A9crit :<br>
<div class=3D"Ih2E3d">> On Mon, Jan 19, 2009 at 6:56 PM, Jaume Sabater &=
lt;<a href=3D"mailto:jsabater [at] gmail.com">jsabater [at] gmail.com</a>> wrote:<=
br>
><br>
>> And I am in the process of writing a bunch of scripts that the Zab=
bix<br>
>> agent will execute to feed the server with information, so that al=
erts<br>
>> and graphs can be produced.<br>
><br>
><br>
> Oh, I have exactly the same in my plans. Where it would possible to do=
wnload<br>
> them (if would)?<br>
><br>
<br>
</div>I did something in that way, check_postgres.pl is a good script to st=
art from<br>
(add a zabbix output perhaps).  I stop working on that because zabbix =
is too<br>
painfull to use (*for me*).<br>
<br>
Here some draft note about zabbix+check_postgres...Hope it can help.</block=
quote><br>Thank you, it is good starting point, but I'm going to create=
template and graphs for it, and it can take many time.<br></div><br>-- <br=
>
Vladimir Rusinov<br><a href=3D"http://greenmice.info/">http://greenmice.inf=
o/</a><br>

--0015174c0eca095f5604611603ad--

--0015174c3f5c682093046115f8e4
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

On Wed, Jan 21, 2009 at 8:30 PM, Jaume Sabater <jsabater [at] gmail.com> wrote:

> On Wed, Jan 21, 2009 at 5:51 PM, Vladimir Rusinov
> <vladimir [at] greenmice.info> wrote:
>
> >> And I am in the process of writing a bunch of scripts that the Zabbix
> >> agent will execute to feed the server with information, so that alerts
> >> and graphs can be produced.
> >
> > Oh, I have exactly the same in my plans. Where it would possible to
> download
> > them (if would)?
>
> Of course you would but, honestly, it is not on top of my TODO list. I
> will have to do them, eventually, but I don't see it happening in the
> next 4 weeks. Feel free to get started with something and I'll
> contribute with what I have as soon as I can (quite busy at work at
> the moment, sorry). :)


Don't worry, I understand you. I'm just asking where I could find if your
tools are completed and compare it to mine. Are you going to post link to
this list?
It's also not on top of my TODO list, and I also think it should not be
ready earlier then in 2-3 weeks. I'll post my templates and scripts to
http://greenmice.info/ It's mostly on russian, but I'm translating most
interesting posts to english, but it could take one more week. :( And I can
also post link to this list if anyone interesed.

--
Vladimir Rusinov
http://greenmice.info/

--0015174c3f5c682093046115f8e4
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<br><br> <br><br><div class=3D"gmail_quote">On Wed, Jan 21, 2009 at 8:30 PM=
, Jaume Sabater <span dir=3D"ltr"><<a href=3D"mailto:jsabater [at] gmail.com"=
>jsabater [at] gmail.com</a>></span> wrote:<br><blockquote class=3D"gmail_quo=
te" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt=
0.8ex; padding-left: 1ex;">
<div class=3D"Ih2E3d">On Wed, Jan 21, 2009 at 5:51 PM, Vladimir Rusinov<br>
<<a href=3D"mailto:vladimir [at] greenmice.info">vladimir [at] greenmice.info</a>&=
gt; wrote:<br>
<br>
>> And I am in the process of writing a bunch of scripts that the Zab=
bix<br>
>> agent will execute to feed the server with information, so that al=
erts<br>
>> and graphs can be produced.<br>
><br>
> Oh, I have exactly the same in my plans. Where it would possible to do=
wnload<br>
> them (if would)?<br>
<br>
</div>Of course you would but, honestly, it is not on top of my TODO list. =
I<br>
will have to do them, eventually, but I don't see it happening in the<b=
r>
next 4 weeks. Feel free to get started with something and I'll<br>
contribute with what I have as soon as I can (quite busy at work at<br>
the moment, sorry). :)</blockquote><div><br>Don't worry, I understand y=
ou. I'm just asking where I could find if your tools are completed and =
compare it to mine. Are you going to post link to this list?<br>It's al=
so not on top of my TODO list, and I also think it should not be ready earl=
ier then in 2-3 weeks. I'll post my templates and scripts to <a href=3D=
"http://greenmice.info/">http://greenmice.info/</a> It's mostly on russ=
ian, but I'm translating most interesting posts to english, but it coul=
d take one more week. :( And I can also post link to this list if anyone in=
teresed.<br>
</div></div><br>-- <br>Vladimir Rusinov<br><a href=3D"http://greenmice.info=
/">http://greenmice.info/</a><br>

--0015174c3f5c682093046115f8e4--

--001485f90f66832c0c047a37a769
Content-Type: text/plain; charset=ISO-8859-1

Hello admins,

Based on these monitoring needs, I've posted an article called *"PostgreSQL
monitoring on ZABBIX"* where I set up some parameters such as database size,
cache hit ratio and success rate:

http://agajorte.blogspot.com/2009/12/postgresql-monitoring-o n-zabbix.html

I also found out *Vladimir's Zabbix Templates Collection*, where several
DBMS items are considered:

http://greenmice.info/en/node/136

For those interested in the subject: do you think there is any other
valuable PostgreSQL-specific item to be monitored?

--
Best regards,

Rodrigo Hjort
SERPRO/CETEC/Curitiba
www.serpro.gov.br


2009/1/22 Vladimir Rusinov <vladimir [at] greenmice.info>

>
> On Wed, Jan 21, 2009 at 8:30 PM, Jaume Sabater <jsabater [at] gmail.com> wrote:
>
>> On Wed, Jan 21, 2009 at 5:51 PM, Vladimir Rusinov
>> <vladimir [at] greenmice.info> wrote:
>>
>> >> And I am in the process of writing a bunch of scripts that the Zabbix
>> >> agent will execute to feed the server with information, so that alerts
>> >> and graphs can be produced.
>> >
>> > Oh, I have exactly the same in my plans. Where it would possible to
>> download
>> > them (if would)?
>>
>> Of course you would but, honestly, it is not on top of my TODO list. I
>> will have to do them, eventually, but I don't see it happening in the
>> next 4 weeks. Feel free to get started with something and I'll
>> contribute with what I have as soon as I can (quite busy at work at
>> the moment, sorry). :)
>
>
> Don't worry, I understand you. I'm just asking where I could find if your
> tools are completed and compare it to mine. Are you going to post link to
> this list?
> It's also not on top of my TODO list, and I also think it should not be
> ready earlier then in 2-3 weeks. I'll post my templates and scripts to
> http://greenmice.info/ It's mostly on russian, but I'm translating most
> interesting posts to english, but it could take one more week. :( And I can
> also post link to this list if anyone interesed.
>
> --
> Vladimir Rusinov
> http://greenmice.info/
>

--001485f90f66832c0c047a37a769
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello admins,<br><br>Based on these monitoring needs, I've posted an ar=
ticle called <b>"PostgreSQL monitoring on ZABBIX"</b> where I set=
up some parameters such as database size, cache hit ratio and success rate=
:<br>
<br><a href=3D"http://agajorte.blogspot.com/2009/12/postgresql-monitoring-o=
n-zabbix.html">http://agajorte.blogspot.com/2009/12/postgres ql-monitoring-o=
n-zabbix.html</a><br><br>I also found out <b>Vladimir's Zabbix Template=
s Collection</b>, where several DBMS items are considered:<br>
<br>
<a href=3D"http://greenmice.info/en/node/136">http://greenmice.info/en/node=
/136</a><br><br>For those interested in the subject: do you think there is =
any other valuable PostgreSQL-specific item to be monitored?<br><br>-- <br>
Best regards,<br><br>Rodrigo Hjort<br>SERPRO/CETEC/Curitiba<br><a href=3D"h=
ttp://www.serpro.gov.br" target=3D"_blank">www.serpro.gov.br</a><br><br><br=
><div class=3D"gmail_quote">2009/1/22 Vladimir Rusinov <span dir=3D"ltr">&l=
t;<a href=3D"mailto:vladimir [at] greenmice.info" target=3D"_blank">vladimir [at] gre=
enmice.info</a>></span><br>

<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <br><div class=
=3D"gmail_quote"><div>On Wed, Jan 21, 2009 at 8:30 PM, Jaume Sabater <span =
dir=3D"ltr"><<a href=3D"mailto:jsabater [at] gmail.com" target=3D"_blank">jsa=
bater [at] gmail.com</a>></span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>On Wed, Jan 21, 2009 at 5:51 PM, Vladimir Rusinov<br>
<<a href=3D"mailto:vladimir [at] greenmice.info" target=3D"_blank">vladimir [at] g=
reenmice.info</a>> wrote:<br>
<br>
>> And I am in the process of writing a bunch of scripts that the Zab=
bix<br>
>> agent will execute to feed the server with information, so that al=
erts<br>
>> and graphs can be produced.<br>
><br>
> Oh, I have exactly the same in my plans. Where it would possible to do=
wnload<br>
> them (if would)?<br>
<br>
</div>Of course you would but, honestly, it is not on top of my TODO list. =
I<br>
will have to do them, eventually, but I don't see it happening in the<b=
r>
next 4 weeks. Feel free to get started with something and I'll<br>
contribute with what I have as soon as I can (quite busy at work at<br>
the moment, sorry). :)</blockquote></div><div><br>Don't worry, I unders=
tand you. I'm just asking where I could find if your tools are complete=
d and compare it to mine. Are you going to post link to this list?<br>

It's also not on top of my TODO list, and I also think it should not be=
ready earlier then in 2-3 weeks. I'll post my templates and scripts to=
<a href=3D"http://greenmice.info/" target=3D"_blank">http://greenmice.info=
/</a> It's mostly on russian, but I'm translating most interesting =
posts to english, but it could take one more week. :( And I can also post l=
ink to this list if anyone interesed.<br>


</div></div><div><div></div><div><br>-- <br>Vladimir Rusinov<br><a href=3D"=
http://greenmice.info/" target=3D"_blank">http://greenmice.info/</a><br>
</div></div></blockquote></div><br>

--001485f90f66832c0c047a37a769--