pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
The server lacks instrumentation functions
7+ messages / 6 participants
[nested] [flat]

* The server lacks instrumentation functions
@ 2006-09-21 17:53  Thomas Vatter <thomas.vatter@network-inventory.de>
  0 siblings, 1 reply; 7+ messages in thread

From: Thomas Vatter @ 2006-09-21 17:53 UTC (permalink / raw)
  To: pgsql-admin

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.





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: The server lacks instrumentation functions
@ 2006-09-22 02:52  Jim Nasby <jimn@enterprisedb.com>
  parent: Thomas Vatter <thomas.vatter@network-inventory.de>
  0 siblings, 1 reply; 7+ messages in thread

From: Jim Nasby @ 2006-09-22 02:52 UTC (permalink / raw)
  To: Thomas Vatter <thomas.vatter@network-inventory.de>; +Cc: pgsql-admin

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. :)
--
Jim Nasby                                    jimn@enterprisedb.com
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)


--
Jim Nasby                                    jimn@enterprisedb.com
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: The server lacks instrumentation functions
@ 2006-09-22 13:32  Guillaume Lelarge <guillaume@lelarge.info>
  parent: Jim Nasby <jimn@enterprisedb.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Guillaume Lelarge @ 2006-09-22 13:32 UTC (permalink / raw)
  To: Thomas Vatter <thomas.vatter@network-inventory.de>; +Cc: Jim Nasby <jimn@enterprisedb.com>; pgsql-admin

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

Regards.


-- 
Guillaume.



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: The server lacks instrumentation functions
@ 2006-09-25 21:57  August Zajonc <augustz@augustz.com>
  parent: Guillaume Lelarge <guillaume@lelarge.info>
  0 siblings, 1 reply; 7+ messages in thread

From: August Zajonc @ 2006-09-25 21:57 UTC (permalink / raw)
  To: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: The server lacks instrumentation functions
@ 2006-09-26 00:16  Joshua D. Drake <jd@commandprompt.com>
  parent: August Zajonc <augustz@augustz.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Joshua D. Drake @ 2006-09-26 00:16 UTC (permalink / raw)
  To: August Zajonc <augustz@augustz.com>; +Cc: pgsql-admin

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.

Joshua D. Drake


> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 


-- 

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: The server lacks instrumentation functions
@ 2006-09-26 00:55  August Zajonc <augustz@augustz.com>
  parent: Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 1 reply; 7+ messages in thread

From: August Zajonc @ 2006-09-26 00:55 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: The server lacks instrumentation functions
@ 2006-09-26 01:44  Tom Lane <tgl@sss.pgh.pa.us>
  parent: August Zajonc <augustz@augustz.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2006-09-26 01:44 UTC (permalink / raw)
  To: August Zajonc <augustz@augustz.com>; +Cc: Joshua D. Drake <jd@commandprompt.com>; pgsql-admin

August Zajonc <augustz@augustz.com> writes:
> 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.

AFAICS, contrib/adminpack has approximately nothing to do with
"instrumentation".

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2006-09-26 01:44 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-21 17:53 The server lacks instrumentation functions Thomas Vatter <thomas.vatter@network-inventory.de>
2006-09-22 02:52 ` Jim Nasby <jimn@enterprisedb.com>
2006-09-22 13:32   ` Guillaume Lelarge <guillaume@lelarge.info>
2006-09-25 21:57     ` August Zajonc <augustz@augustz.com>
2006-09-26 00:16       ` Joshua D. Drake <jd@commandprompt.com>
2006-09-26 00:55         ` August Zajonc <augustz@augustz.com>
2006-09-26 01:44           ` Tom Lane <tgl@sss.pgh.pa.us>

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