Monitoring Pg servers with Microsoft SCOM

On 5/4/2014 4:17 PM, Glen Eustace wrote:

I am in the process of deploying Microsoft System Centre Operations
Manager and was hoping that somebody had either developed or knew of
where I could get hold of a management pack for PostgreSQL.

I am not sure whether there is an instrumentation interface into the
DB so haven't yet looked at rolling our own.

if you have perl (strawberryperl ?) on the postgres server, you could
use the checkpostgresql.pl script meant for Nagios from the Bucardo
folks, it will allow you to poll for 100s of status and performance
metrics, even things like table bloat.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 05/04/2014 04:17 PM, Glen Eustace wrote:

I am in the process of deploying Microsoft System Centre Operations
Manager and was hoping that somebody had either developed or knew of
where I could get hold of a management pack for PostgreSQL.

I am not sure whether there is an instrumentation interface into the DB
so haven't yet looked at rolling our own.

Any comments appreciated.

Searches on this all seem to point back to this post:

http://blogs.technet.com/b/kevinholman/archive/2012/03/19/opsmgr-how-to-monitor-non-microsoft-sql-databases-in-scom-an-example-using-postgre-sql.aspx

Glen

--

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 5/05/2014, at 12:26 pm, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

On 05/04/2014 04:17 PM, Glen Eustace wrote:

I am in the process of deploying Microsoft System Centre Operations
Manager and was hoping that somebody had either developed or knew of
where I could get hold of a management pack for PostgreSQL.

I am not sure whether there is an instrumentation interface into the DB
so haven't yet looked at rolling our own.

Any comments appreciated.

Searches on this all seem to point back to this post:

http://blogs.technet.com/b/kevinholman/archive/2012/03/19/opsmgr-how-to-monitor-non-microsoft-sql-databases-in-scom-an-example-using-postgre-sql.aspx

Yes, I had seen that. I was more interested in being able to instrument the Pg internals, connection counts, transaction rates, RAM usage etc. In a similar sort of way to MS-SQL.

Running transactions against an individual DB is still useful but I was hoping to do better.

Glen

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

I am in the process of deploying Microsoft System Centre Operations Manager and was hoping that somebody had either developed or knew of where I could get hold of a management pack for PostgreSQL.

I am not sure whether there is an instrumentation interface into the DB so haven't yet looked at rolling our own.

Any comments appreciated.

Glen

Have you looked into this?

http://pg-monz.github.io/pg_monz/index-en.html

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 5/05/2014, at 3:18 pm, Tatsuo Ishii <ishii@postgresql.org> wrote:

I am in the process of deploying Microsoft System Centre Operations Manager and was hoping that somebody had either developed or knew of where I could get hold of a management pack for PostgreSQL.

I am not sure whether there is an instrumentation interface into the DB so haven't yet looked at rolling our own.

Any comments appreciated.

Glen

Have you looked into this?

http://pg-monz.github.io/pg_monz/index-en.html

Unfortunately the goal is integration of services with SCOM as opposed to monitoring PostgreSQL so I don't get a choice of platform.

Glen.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Mon, May 5, 2014 at 3:15 AM, Glen Eustace <geustace@godzone.net.nz>wrote:

On 5/05/2014, at 12:26 pm, Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 05/04/2014 04:17 PM, Glen Eustace wrote:

I am in the process of deploying Microsoft System Centre Operations
Manager and was hoping that somebody had either developed or knew of
where I could get hold of a management pack for PostgreSQL.

I am not sure whether there is an instrumentation interface into the DB
so haven't yet looked at rolling our own.

Any comments appreciated.

Searches on this all seem to point back to this post:

http://blogs.technet.com/b/kevinholman/archive/2012/03/19/opsmgr-how-to-monitor-non-microsoft-sql-databases-in-scom-an-example-using-postgre-sql.aspx

Yes, I had seen that. I was more interested in being able to instrument
the Pg internals, connection counts, transaction rates, RAM usage etc. In
a similar sort of way to MS-SQL.

Running transactions against an individual DB is still useful but I was
hoping to do better.

As long as you can run arbitrary SQL, you can get all the information out.
Assuming it can do something with it rather than just run a plain query. If
so, I suggest you take a look at the check_postgres nagios plugin or the
munin plugins for some examples of which SQL to run to get the interesting
metrics back that you want. Some quick googling shows several examples of
how to monitor with custom SQL queries, but I don't know enough (or
anything) about SCOM to recommend any of them in particular.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

On 6/05/2014, at 1:30 am, Magnus Hagander <magnus@hagander.net> wrote:

As long as you can run arbitrary SQL, you can get all the information out. Assuming it can do something with it rather than just run a plain query. If so, I suggest you take a look at the check_postgres nagios plugin or the munin plugins for some examples of which SQL to run to get the interesting metrics back that you want. Some quick googling shows several examples of how to monitor with custom SQL queries, but I don't know enough (or anything) about SCOM to recommend any of them in particular.

Thanks, that is the conclusion I had come to as well. I have written a management pack for collection other Linux data so may have a go at a PostgreSQL one if I get some time.

On 5/5/2014 12:43 PM, Glen Eustace wrote:

Thanks, that is the conclusion I had come to as well. I have written
a management pack for collection other Linux data so may have a go at
a PostgreSQL one if I get some time.

I would just use check_postgres (perl) from your agent script...

--
john r pierce 37N 122W
somewhere on the middle of the left coast

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 7/05/2014, at 3:07 am, pgsql-general-owner@postgresql.org wrote:

I would just use check_postgres (perl) from your agent script...

Having downloaded and had a look at this script I would agree. I'll let check_postgresl do the heavy lifting and just try and get a build an MP that collects the output from the various actions.

Thanks.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general