From: Fred Parkinson <FredP@abag.ca.gov>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: pgsql-admin@postgresql.org
Subject: Re: adminpack installed?
Date: Mon, 13 Dec 2010 12:41:47 -0800
Message-ID: <4D06148B020000A700015223@gwia1.abag.ca.gov> (raw)
In-Reply-To: <4D0662F4.9090408@lelarge.info>
References: <4D05E73C020000A700015208@gwia1.abag.ca.gov>
<4D0662F4.9090408@lelarge.info>
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> 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.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: FredP@abag.ca.gov, guillaume@lelarge.info
Subject: Re: adminpack installed?
In-Reply-To: <4D06148B020000A700015223@gwia1.abag.ca.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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