Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id F32AD1337B67 for ; Mon, 13 Dec 2010 16:41:58 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 16115-06 for ; Mon, 13 Dec 2010 20:41:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from pp-ag1.abag.ca.gov (pp-ag1.abag.ca.gov [198.31.87.11]) by mail.postgresql.org (Postfix) with ESMTP id 933BD1336971 for ; Mon, 13 Dec 2010 16:41:50 -0400 (AST) Received: from pps.filterd (pp-ag1 [127.0.0.1]) by pp-ag1.abag.ca.gov (8.14.3/8.14.3) with SMTP id oBDKfn0h012653 for ; Mon, 13 Dec 2010 12:41:49 -0800 Received: from gwia1.abag.ca.gov (gwia1.abag.ca.gov [198.31.87.27]) by pp-ag1.abag.ca.gov with ESMTP id t3yvb0dqa-1 for ; Mon, 13 Dec 2010 12:41:49 -0800 Received: from d02-MTA by gwia1.abag.ca.gov with Novell_GroupWise; Mon, 13 Dec 2010 12:41:48 -0800 Message-Id: <4D06148B020000A700015223@gwia1.abag.ca.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.2 Date: Mon, 13 Dec 2010 12:41:47 -0800 From: "Fred Parkinson" To: "Guillaume Lelarge" Cc: Subject: Re: adminpack installed? References: <4D05E73C020000A700015208@gwia1.abag.ca.gov> <4D0662F4.9090408@lelarge.info> In-Reply-To: <4D0662F4.9090408@lelarge.info> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__PartBD91FB1B.1__=" X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.2.15, 1.0.148, 0.0.0000 definitions=2010-12-13_07:2010-12-13, 2010-12-13, 1970-01-01 signatures=0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.209 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/100 X-Sequence-Number: 36329 This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=__PartBD91FB1B.1__= Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Thanks again for your great help. I ran adminpack.sql in the query window and it returned 'success'. I actually did read the complete message and it was (slightly) vague enough that I thought there was a chance it didn't just apply to the windows installer. Thanks for your expert help. Fred >>> Guillaume Lelarge 12/13/2010 10:16 AM >>> Le 13/12/2010 18:28, Fred Parkinson a écrit : > New to managing postgresql, I hope my questions are not a burden to this group, but I have another. > > I have installed version 8.4.5 of postgresql, 1.12.1 of pgadmin3. > > When I invoke pgadmin3 from a terminal prompt I get the message that > "The server lacks instrumentation functions....adminpack is installed and activated by default...is included as a contrib module with all versions of PostgreSQL 8.2 and above...copy the appropriate adminpack source code ..." > With special parameters then, because you only have this message when you launch the server status window. > Yet adminpack.sql already exists in /contrib and according to the message, is activated by default in 8.4.5. > You need to read the complete message: "The adminpack is installed and activated by default *if you are running the 'official' pgInstaller distribution of PostgreSQL for Windows*". Which, BTW, should say the onclick installer. Will fix this. Anyway, as you use Yast, I suppose the server is not installed on a Windows box :) > I installed postgresql using Yast, set PGLIB and PGDATA by hand, changed ownership to postgres and ran initdb to initialize it. > (I don't recall if I downloaded pgadmin3 from postgresql.org or used Yast to install it. In Yast the version number of pgadmin3 is in red (?), so maybe I downloaded it by hand.) > > Do I need to do something to tell the system adminpack is already available, or something else? > Sure. You need to execute the adminpack.sql file in the postgres database. This is automatically done with the Windows installer because it also installs pgAdmin3. But you need to do it yourself on Linux. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin --=__PartBD91FB1B.1__= Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Description: HTML
Thanks again for your great help.
 
I ran adminpack.sql in the query window and it returned 'success'.
 
I actually did read the complete message and it was (slightly) vague = enough that I thought there was a chance it didn't just apply to the = windows installer.
 
Thanks for your expert help.
 
Fred

>>> Guillaume Lelarge <guillaume@lelarge.info&= gt; 12/13/2010 10:16 AM >>>
Le 13/12/2010 18:28, Fred = Parkinson a =C3=A9crit :
> New to managing postgresql, I hope my = questions are not a burden to this group, but I have another.
> =
> I have installed version 8.4.5 of postgresql, 1.12.1 of = pgadmin3.
> 
> When I invoke pgadmin3 from a terminal = prompt I get the message that
> "The server lacks instrumentation = functions....adminpack is installed and activated by default...is included = as a contrib module with all versions of PostgreSQL 8.2 and above...copy = the appropriate adminpack source code ..."
> 

With = special parameters then, because you only have this message when
you = launch the server status window.

> Yet adminpack.sql already = exists in /contrib and according to the message, is activated by default = in 8.4.5.
> 

You need to read the complete message: = "The adminpack is installed and
activated by default *if you are = running the 'official' pgInstaller
distribution of PostgreSQL for = Windows*".

Which, BTW, should say the onclick installer. Will fix = this.

Anyway, as you use Yast, I suppose the server is not = installed on a
Windows box :)

> I installed postgresql using = Yast, set PGLIB and PGDATA by hand, changed ownership to postgres and ran = initdb to initialize it.
> (I don't recall if I downloaded pgadmin3 = from postgresql.org or used Yast to install it. In Yast the version number = of pgadmin3 is in red (?), so maybe I downloaded it by hand.)
> =
> Do I need to do something to tell the system adminpack is = already available, or something else?
> 

Sure. You need = to execute the adminpack.sql file in the postgres database.

This is = automatically done with the Windows installer because it also
installs = pgAdmin3. But you need to do it yourself on Linux.


--
Guilla= ume
http://www.postgresql.frhttp://dalibo.com

--
Sent = via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make = changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--=__PartBD91FB1B.1__=--