Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?, mysql feiertage, bash netcat eof, 192.168.1.41:8000

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