Enterprise pg database monitoring

Enterprise pg database monitoring

am 24.08.2010 11:35:43 von 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






Hi=2C

I was interested in finding out how other people are monitorin=
g their postgres database estates.
We use psql and pgAdmin for day to da=
y dba admin tasks=2C but I was wondering if there were any
good tools a=
vailable for monitoring such things as whether all of my postgres cluster's=
were up and
running (similar to oracle enterprise manager dare i say i=
t)? Are people just using shell scripts
scheduled from cron to check su=
ch things? This could become an issue if you had 100's of postgres
inst=
ances 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 pgF=
ouine which is very useful=2C and I've
also just found pgStatspack=2C b=
ut are there any other modules=2C scripts or tools that
you would recom=
mend to help with database administration? They don't necessarilly have to =
be free either =3B-)

Thanks in advance.

=

--_26d9482a-b1e6-40f8-82b6-ad8d00e48bcb_--

Re: Enterprise pg database monitoring

am 24.08.2010 11:44:14 von 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

Re: Enterprise pg database monitoring

am 24.08.2010 11:51:13 von 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

Re: Enterprise pg database monitoring

am 24.08.2010 12:33:08 von 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






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

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

=

--_ec43ed55-a336-4c49-8edc-122a72a4488c_--

Re: Enterprise pg database monitoring

am 24.08.2010 15:25:23 von 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




http-equiv="Content-Type">


On 10-08-24 05:35 AM, Kieren Scott wrote:

type="cite">

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--