Thread: Admin-Functions in Ubuntu's PG 8.2 missing?
Hi, 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. Is there some magic to do on a config-filie or someting?
Andreas wrote:
> Hi,
>
> 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?
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
=== 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/
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?
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/