Thread: Monitoring Pg servers with Microsoft SCOM
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
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 4446
Ph: +64 6 357 8168, Fax: +64 6 357 8165, Mob: +64 27 542 4015
"Specialising in providing low-cost professional Internet Services since 1997"
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 4446
Ph: +64 6 357 8168, Fax: +64 6 357 8165, Mob: +64 27 542 4015
"Specialising in providing low-cost professional Internet Services since 1997"
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
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
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, transactionrates, 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
> I am in the process of deploying Microsoft System Centre Operations Manager and was hoping that somebody had either developedor 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
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 developedor 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 ofplatform. Glen.
On Mon, May 5, 2014 at 3:15 AM, Glen Eustace <geustace@godzone.net.nz> wrote:
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.
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
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
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 tryand get a build an MP that collects the output from the various actions. Thanks.