Re: [GENERAL] Monitoring Pg servers with Microsoft SCOM
On 7/05/2014, at 3:07 am, pgsql-general-ow...@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
Re: [GENERAL] Monitoring Pg servers with Microsoft SCOM
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
Re: [GENERAL] Monitoring Pg servers with Microsoft SCOM
On 6/05/2014, at 1:30 am, Magnus Hagander 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.
Re: [GENERAL] Monitoring Pg servers with Microsoft SCOM
On Mon, May 5, 2014 at 3:15 AM, Glen Eustace wrote: > > On 5/05/2014, at 12:26 pm, Adrian Klaver > 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/
Re: [GENERAL] Monitoring Pg servers with Microsoft SCOM
On 5/05/2014, at 3:18 pm, Tatsuo Ishii 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
Re: [GENERAL] 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 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
Re: [GENERAL] Monitoring Pg servers with Microsoft SCOM
On 5/05/2014, at 12:26 pm, Adrian Klaver 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
Re: [GENERAL] Monitoring Pg servers with Microsoft SCOM
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.kla...@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
Re: [GENERAL] 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
[GENERAL] 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"