pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedEnterprise pg database monitoring
5+ messages / 4 participants
[nested] [flat]
* Enterprise pg database monitoring
@ 2010-08-24 09:35 Kieren Scott <kierenscott@hotmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Kieren Scott @ 2010-08-24 09:35 UTC (permalink / raw)
To: pgsql-admin
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...
On the database performance side of things, I've looked at pgFouine which is very useful, and I've
also just found pgStatspack, but are there any other modules, scripts or tools that
you would recommend to help with database administration? They don't necessarilly have to be free either ;-)
Thanks in advance.
=
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Enterprise pg database monitoring
@ 2010-08-24 09:44 Jens Wilke <jens.wilke@affinitas.de>
parent: Kieren Scott <kierenscott@hotmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Jens Wilke @ 2010-08-24 09:44 UTC (permalink / raw)
To: pgsql-admin
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ße 41/43 | 10999 Berlin | Germany
Geschäftsführer: Lukas Brosseder, David Khalil, Kai Rieke, Christian Vollmann
Eingetragen beim Amtsgericht Berlin, HRB 115958
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Enterprise pg database monitoring
@ 2010-08-24 09:51 Guillaume Lelarge <guillaume@lelarge.info>
parent: Jens Wilke <jens.wilke@affinitas.de>
0 siblings, 1 reply; 5+ messages in thread
From: Guillaume Lelarge @ 2010-08-24 09:51 UTC (permalink / raw)
To: Jens Wilke <jens.wilke@affinitas.de>; +Cc: pgsql-admin
Le 24/08/2010 11:44, Jens Wilke a écrit :
> 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.
>
Yeah, that's what we use too. check_postgres is an incredibly great
little tool.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Enterprise pg database monitoring
@ 2010-08-24 10:33 Kieren Scott <kierenscott@hotmail.com>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 5+ messages in thread
From: Kieren Scott @ 2010-08-24 10:33 UTC (permalink / raw)
To: guillaume@lelarge.info; jens.wilke@affinitas.de; +Cc: pgsql-admin
Excellent, I'll take a look. Although we don't use nagios, it looks as though we can use this
in standalone scripts, so could be very useful.
Kieren
> Date: Tue, 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
>
> Le 24/08/2010 11:44, Jens Wilke a écrit :
> > 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.
> >
>
> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
=
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Enterprise pg database monitoring
@ 2010-08-24 13:25 Brad Nicholson <bnichols@ca.afilias.info>
parent: Kieren Scott <kierenscott@hotmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Brad Nicholson @ 2010-08-24 13:25 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-08-24 13:25 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-08-24 09:35 Enterprise pg database monitoring Kieren Scott <kierenscott@hotmail.com>
2010-08-24 09:44 ` Jens Wilke <jens.wilke@affinitas.de>
2010-08-24 09:51 ` Guillaume Lelarge <guillaume@lelarge.info>
2010-08-24 10:33 ` Kieren Scott <kierenscott@hotmail.com>
2010-08-24 13:25 ` Brad Nicholson <bnichols@ca.afilias.info>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox