Enterprise pg database monitoring

--_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
good tools available for monitoring such things as whether all of my postgr=
es cluster's were up and
running (similar to oracle enterprise manager dare i say it)? Are people ju=
st 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...

On the database performance side of things=2C I've looked at pgFouine which=
is very useful=2C and I've
also just found pgStatspack=2C but are there any other modules=2C scripts o=
r tools that
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_--
Kieren Scott [ Di, 24 August 2010 11:35 ] [ ID #2046541 ]

Re: Enterprise pg database monitoring

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

Have a look for nagios check_postgres.

Rgds, Jens

--
Affinitas GmbH | Kohlfurter Stra=C3=9Fe 41/43 | 10999 Berlin | Germany

Gesch=C3=A4ftsf=C3=BChrer: Lukas Brosseder, David Khalil, Kai Rieke, Christ=
ian Vollmann
Eingetragen beim Amtsgericht Berlin, HRB 115958

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Jens Wilke [ Di, 24 August 2010 11:44 ] [ ID #2046543 ]

Re: Enterprise pg database monitoring

Le 24/08/2010 11:44, Jens Wilke a =C3=A9crit :
> 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 we=
re up
>> and running
>
> Have a look for nagios check_postgres.
>

Yeah, that's what we use too. check_postgres is an incredibly great
little tool.


--
Guillaume
http://www.postgresql.fr
http://dalibo.com

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Guillaume Lelarge [ Di, 24 August 2010 11:51 ] [ ID #2046544 ]

Re: Enterprise pg database monitoring

--_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 [at] lelarge.info
> To: jens.wilke [at] affinitas.de
> CC: pgsql-admin [at] postgresql.org
> Subject: Re: [ADMIN] Enterprise pg database monitoring
>
> Le 24/08/2010 11:44=2C Jens Wilke a =E9crit :
> > Am Dienstag 24 August 2010 11:35:43 schrieb Kieren Scott:
> >
> > Hi Kieren=2C
> >
> >> 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
> >
> > Have a look for nagios check_postgres.
> >
>
> Yeah=2C that's what we use too. check_postgres is an incredibly great
> little tool.
>
>
> --
> Guillaume
> http://www.postgresql.fr
> http://dalibo.com
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin [at] 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 [at] lelarge.info<br>>=3B To: jens.wilke [at] affinitas.de<br>&=
gt=3B CC: pgsql-admin [at] 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 [at] 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_--
Kieren Scott [ Di, 24 August 2010 12:33 ] [ ID #2046545 ]

Re: Enterprise pg database monitoring

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 [at] 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--
Brad Nicholson [ Di, 24 August 2010 15:25 ] [ ID #2046547 ]
Datenbanken » gmane.comp.db.postgresql.admin » Enterprise pg database monitoring

Vorheriges Thema: Postgresql 8.3 on OSX hangs
Nächstes Thema: pgBouncer for connection pooling

[ Startseite ] [ Administrator ] [ Suche ] [ Hinweise ] [ Impressum ]

Powered by FudForum