Re: Admin-Functions in Ubuntu's PG 8.2 missing?

Andreas wrote:
>
> Joshua D. Drake schrieb:
>> Andreas wrote:
>>> I've got an Ubuntu 7.04 (Feisty Fawn) set up and it has Ubuntu's
>>> binary PG 8.2.4 running.
>>> If I connect with a pgAdmin3 1.6.3 from Windows
>>>   Tools --> Server Status
>>> pgAdmin complains that "The server lacks instrumentation functions.
>>> pgAdmin III uses some support funtions ..."
>>>
>>> I though those functions were included by default beginning with PG 8.2.
>>> At least I didn't find an adminpack in Ubuntu's package manager.
>>
>> They are in contrib... try installing postgresql-8.2-contrib
>>
>>>
>>> Is there some magic to do on a config-filie or someting?
>
>
> Actually the package   postgresql-contrib-8.2  is installed as default.
> Are you sure that one doesn't have to activate the admin-stuff somewhere
> in the config of PG?

Yes you do have to activate them. You have to apply the sql for the
functions against your database.

Joshua D. Drake

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org/
>


--

       === 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/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/