#1: Enterprise pg database monitoring
Posted on 2010-08-24 11:35:43 by Kieren Scott
--_26d9482a-b1e6-40f8-82b6-ad8d00e48bcb_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi=2C
I was interested in finding out how other people are monitoring their postg=
res database estates.
We use psql and pgAdmin for day to day dba admin tasks=2C but I was wonderi=
ng if there were any=20
good tools available for monitoring such things as whether all of my postgr=
es cluster's were up and=20
running (similar to oracle enterprise manager dare i say it)? Are people ju=
st using shell scripts=20
scheduled from cron to check such things? This could become an issue if you=
had 100's of postgres=20
instances and you need to roll out new monitoring scripts and cron jobs to =
each...
On the database performance side of things=2C I've looked at pgFouine which=
is very useful=2C and I've=20
also just found pgStatspack=2C but are there any other modules=2C scripts o=
r tools that=20
you would recommend to help with database administration? They don't necess=
arilly have to be free either =3B-)
Thanks in advance.
=
--_26d9482a-b1e6-40f8-82b6-ad8d00e48bcb_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style><!--
..hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Tahoma
}
--></style>
</head>
<body class=3D'hmmessage'>
Hi=2C<br><br>I was interested in finding out how other people are monitorin=
g their postgres database estates.<br>We use psql and pgAdmin for day to da=
y dba admin tasks=2C but I was wondering if there were any <br>good tools a=
vailable for monitoring such things as whether all of my postgres cluster's=
were up and <br>running (similar to oracle enterprise manager dare i say i=
t)? Are people just using shell scripts <br>scheduled from cron to check su=
ch things? This could become an issue if you had 100's of postgres <br>inst=
ances and you need to roll out new monitoring scripts and cron jobs to each=
....<br><br>On the database performance side of things=2C I've looked at pgF=
ouine which is very useful=2C and I've <br>also just found pgStatspack=2C b=
ut are there any other modules=2C scripts or tools that <br>you would recom=
mend to help with database administration? They don't necessarilly have to =
be free either =3B-)<br><br>Thanks in advance.<br> </body>
</html>=
--_26d9482a-b1e6-40f8-82b6-ad8d00e48bcb_--
Report this message |
|
#2: Re: Enterprise pg database monitoring
Posted on 2010-08-24 11:44:14 by Jens Wilke
Am Dienstag 24 August 2010 11:35:43 schrieb Kieren Scott:
Hi Kieren,
> but I was wondering if there were any good tools available
> for monitoring such things as whether all of my postgres cluster's were =
up
> and running=20
Have a look for nagios check_postgres.
Rgds, Jens
--=20
Affinitas GmbH | Kohlfurter StraÃe 41/43 | 10999 Berlin | Germany
Geschäftsführer: Lukas Brosseder, David Khalil, Kai Rieke, Christ=
ian Vollmann
Eingetragen beim Amtsgericht Berlin, HRB 115958
--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Report this message |
#3: Re: Enterprise pg database monitoring
Posted on 2010-08-24 11:51:13 by Guillaume Lelarge
Le 24/08/2010 11:44, Jens Wilke a écrit :
> Am Dienstag 24 August 2010 11:35:43 schrieb Kieren Scott:
>=20
> Hi Kieren,
>=20
>> but I was wondering if there were any good tools available
>> for monitoring such things as whether all of my postgres cluster's we=
re up
>> and running=20
>=20
> Have a look for nagios check_postgres.
>=20
Yeah, that's what we use too. check_postgres is an incredibly great
little tool.
--=20
Guillaume
http://www.postgresql.fr
http://dalibo.com
--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Report this message |
#4: Re: Enterprise pg database monitoring
Posted on 2010-08-24 12:33:08 by Kieren Scott
--_ec43ed55-a336-4c49-8edc-122a72a4488c_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Excellent=2C I'll take a look. Although we don't use nagios=2C it looks as =
though we can use this
in standalone scripts=2C so could be very useful.
Kieren
> Date: Tue=2C 24 Aug 2010 11:51:13 +0200
> From: guillaume@lelarge.info
> To: jens.wilke@affinitas.de
> CC: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Enterprise pg database monitoring
>=20
> Le 24/08/2010 11:44=2C Jens Wilke a =E9crit :
> > Am Dienstag 24 August 2010 11:35:43 schrieb Kieren Scott:
> >=20
> > Hi Kieren=2C
> >=20
> >> but I was wondering if there were any good tools available
> >> for monitoring such things as whether all of my postgres cluster's we=
re up
> >> and running=20
> >=20
> > Have a look for nagios check_postgres.
> >=20
>=20
> Yeah=2C that's what we use too. check_postgres is an incredibly great
> little tool.
>=20
>=20
> --=20
> Guillaume
> http://www.postgresql.fr
> http://dalibo.com
>=20
> --=20
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
=
--_ec43ed55-a336-4c49-8edc-122a72a4488c_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style><!--
..hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Tahoma
}
--></style>
</head>
<body class=3D'hmmessage'>
Excellent=2C I'll take a look. Although we don't use nagios=2C it looks as =
though we can use this<br>in standalone scripts=2C so could be very useful.=
<br><br>Kieren<br><br>>=3B Date: Tue=2C 24 Aug 2010 11:51:13 +0200<br>>=
=3B From: guillaume@lelarge.info<br>>=3B To: jens.wilke@affinitas.de<br>&=
gt=3B CC: pgsql-admin@postgresql.org<br>>=3B Subject: Re: [ADMIN] Enterpr=
ise pg database monitoring<br>>=3B <br>>=3B Le 24/08/2010 11:44=2C Jens=
Wilke a =E9crit :<br>>=3B >=3B Am Dienstag 24 August 2010 11:35:43 sch=
rieb Kieren Scott:<br>>=3B >=3B <br>>=3B >=3B Hi Kieren=2C<br>>=
=3B >=3B <br>>=3B >=3B>=3B but I was wondering if there were any go=
od tools available<br>>=3B >=3B>=3B for monitoring such things as wh=
ether all of my postgres cluster's were up<br>>=3B >=3B>=3B and runn=
ing <br>>=3B >=3B <br>>=3B >=3B Have a look for nagios check_postgr=
es.<br>>=3B >=3B <br>>=3B <br>>=3B Yeah=2C that's what we use too. =
check_postgres is an incredibly great<br>>=3B little tool.<br>>=3B <br>=
>=3B <br>>=3B -- <br>>=3B Guillaume<br>>=3B http://www.postgresql.=
fr<br>>=3B http://dalibo.com<br>>=3B <br>>=3B -- <br>>=3B Sent via=
pgsql-admin mailing list (pgsql-admin@postgresql.org)<br>>=3B To make ch=
anges to your subscription:<br>>=3B http://www.postgresql.org/mailpref/pg=
sql-admin<br> </body>
</html>=
--_ec43ed55-a336-4c49-8edc-122a72a4488c_--
Report this message |
#5: Re: Enterprise pg database monitoring
Posted on 2010-08-24 15:25:23 by Brad Nicholson
This is a multi-part message in MIME format.
--------------000608060008060509050303
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
On 10-08-24 05:35 AM, Kieren Scott wrote:
> Hi,
>
> I was interested in finding out how other people are monitoring their
> postgres database estates.
> We use psql and pgAdmin for day to day dba admin tasks, but I was
> wondering if there were any
> good tools available for monitoring such things as whether all of my
> postgres cluster's were up and
> running (similar to oracle enterprise manager dare i say it)? Are
> people just using shell scripts
> scheduled from cron to check such things? This could become an issue
> if you had 100's of postgres
> instances and you need to roll out new monitoring scripts and cron
> jobs to each...
>
Take a look at Hyperic.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--------------000608060008060509050303
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
On 10-08-24 05:35 AM, Kieren Scott wrote:
<blockquote cite="mid:BAY149-w182D83E88835FE657DF3CAE830@phx.gbl"
type="cite">
<style><!--
..hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
Hi,<br>
<br>
I was interested in finding out how other people are monitoring
their postgres database estates.<br>
We use psql and pgAdmin for day to day dba admin tasks, but I was
wondering if there were any <br>
good tools available for monitoring such things as whether all of
my postgres cluster's were up and <br>
running (similar to oracle enterprise manager dare i say it)? Are
people just using shell scripts <br>
scheduled from cron to check such things? This could become an
issue if you had 100's of postgres <br>
instances and you need to roll out new monitoring scripts and cron
jobs to each...<br>
<br>
</blockquote>
<br>
Take a look at Hyperic.<br>
<pre class="moz-signature" cols="72">--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
</pre>
</body>
</html>
--------------000608060008060509050303--
Report this message |