Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#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>&gt=3B Date: Tue=2C 24 Aug 2010 11:51:13 +0200<br>&gt=
=3B From: guillaume@lelarge.info<br>&gt=3B To: jens.wilke@affinitas.de<br>&=
gt=3B CC: pgsql-admin@postgresql.org<br>&gt=3B Subject: Re: [ADMIN] Enterpr=
ise pg database monitoring<br>&gt=3B <br>&gt=3B Le 24/08/2010 11:44=2C Jens=
Wilke a =E9crit :<br>&gt=3B &gt=3B Am Dienstag 24 August 2010 11:35:43 sch=
rieb Kieren Scott:<br>&gt=3B &gt=3B <br>&gt=3B &gt=3B Hi Kieren=2C<br>&gt=
=3B &gt=3B <br>&gt=3B &gt=3B&gt=3B but I was wondering if there were any go=
od tools available<br>&gt=3B &gt=3B&gt=3B for monitoring such things as wh=
ether all of my postgres cluster's were up<br>&gt=3B &gt=3B&gt=3B and runn=
ing <br>&gt=3B &gt=3B <br>&gt=3B &gt=3B Have a look for nagios check_postgr=
es.<br>&gt=3B &gt=3B <br>&gt=3B <br>&gt=3B Yeah=2C that's what we use too. =
check_postgres is an incredibly great<br>&gt=3B little tool.<br>&gt=3B <br>=
&gt=3B <br>&gt=3B -- <br>&gt=3B Guillaume<br>&gt=3B http://www.postgresql.=
fr<br>&gt=3B http://dalibo.com<br>&gt=3B <br>&gt=3B -- <br>&gt=3B Sent via=
pgsql-admin mailing list (pgsql-admin@postgresql.org)<br>&gt=3B To make ch=
anges to your subscription:<br>&gt=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