Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id CD6229FB261 for ; Mon, 25 Sep 2006 21:55:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 42452-03 for ; Tue, 26 Sep 2006 00:55:47 +0000 (UTC) X-Greylist: delayed 02:58:05.078964 by SQLgrey- Received: from out1.smtp.messagingengine.com (out1.smtp.messagingengine.com [66.111.4.25]) by postgresql.org (Postfix) with ESMTP id 051AD9FB258 for ; Mon, 25 Sep 2006 21:55:46 -0300 (ADT) Received: from frontend3.internal (frontend3.internal [10.202.2.152]) by frontend1.messagingengine.com (Postfix) with ESMTP id 776BEDA92A8; Mon, 25 Sep 2006 20:55:44 -0400 (EDT) Received: from heartbeat1.internal ([10.202.2.160]) by frontend3.internal (MEProxy); Mon, 25 Sep 2006 20:55:47 -0400 X-Sasl-enc: 9KPtIEQlZqEaEye5kXUK23GwQm71DgxqeC+GLOyXRrzs 1159232147 Received: from [192.168.2.101] (c-71-232-79-86.hsd1.ma.comcast.net [71.232.79.86]) by mail.messagingengine.com (Postfix) with ESMTP id 245587542; Mon, 25 Sep 2006 20:55:45 -0400 (EDT) Message-ID: <45187A66.2000804@augustz.com> Date: Mon, 25 Sep 2006 20:55:02 -0400 From: August Zajonc User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 To: "Joshua D. Drake" CC: pgsql-admin@postgresql.org Subject: Re: The server lacks instrumentation functions References: <4512D19C.9070206@network-inventory.de> <97041CBF-88B5-401D-8780-B57D42E63E88@enterprisedb.com> <4513E5EF.4040807@lelarge.info> <451850B0.4060903@augustz.com> <4518714C.2040307@commandprompt.com> In-Reply-To: <4518714C.2040307@commandprompt.com> X-Enigmail-Version: 0.93.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/280 X-Sequence-Number: 23194 Joshua D. Drake wrote: > August Zajonc wrote: >> Guillaume Lelarge wrote: >>> Jim Nasby a ecrit le 22/09/2006 04:52: >>>> On Sep 21, 2006, at 1:53 PM, Thomas Vatter wrote: >>>>> When connection to the server with pgadmin3 there is a warning: >>>>> "The server lacks instrumentation functions ..." >>>>> There may be something wrong with my installation. >>>>> The server is version 8.1.4, it is the version for sles9 >>>>> downloaded as >>>>> rpms from suse. >>>> I don't know, but I'm sure someone on the pgAdmin (not pgsql-admin) >>>> list could help. :) >>> A package has to be installed on the server. admin81 is its name. You >>> can find more infos on : >>> http://www.pgadmin.org/docs/1.4/extend.html >>> >> >> Which really should be integrated into the main distribution. MySQL gets >> it very right here, and comes out of the box with some better standard >> instrumentation. > > It is integrated into the main distribution. It is in contrib and you > can add them as you like. > Apologies for the shortness of my tone. This has just been something that has bothered me for a bit. I see it's made it into /contrib, which is fantastic news! Dave I think actually wrote me about this possibility a while back, so great to see that it has happened! Many of the distributions[1] still haven't picked up the adminpack, so from a casual end users perspective installing the adminpack has been non-trivial. I suspect for the person asking the question it actually remains so even today. Remember that many people are doing binary installs from a distribution. Last time I looked adminpack didn't use PGXS either, though that too may have changed :) Anyways, hopefully all this will be fixed in the 8.2 cycle and the adminpack will become more available everywhere. The reason this is interesting to me is that for me, instrumentation really seemed like a core thing that one would want in a database. Most other databases shipped with a standard interface exposing a fair bit of info. Oracle is ridiculous in this way, but MySQL has some standard basics as well. This meant that many management tools picked up that exported set of information, because it was standardized and they could count on it. The pg adminpack was really driven by pgadmin development, and historically one had to go through pgadmin to get it. Good news, - August [1] OpenSuSE, Fedora Dev, Mandriva