Thanks. I have ran this script and it looks like it is working.
-----Original Message-----
From: Raymond O'Donnell [mailto:rod@iol.ie]
Sent: Tuesday, November 03, 2009 10:51 AM
To: Arnold, Sandra
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Enabling Server Instrumentation on 8.4.1
On 03/11/2009 15:41, Arnold, Sandra wrote:
> I am in the process of trying to enable Server Instrumentation on
> Postgresql 8.4.1. I installed the software using the Linux
> one-click-installer. I have looked for the sql file that is shown on
> the screen that comes up when I try to use the Server Status tool in
> PGAdminIII (see below) but cannot find it. If I see the contrib
> directory under share/postgresql directory does that mean the adminpack
> is installed? Or there something I need to do?
You need to run the adminpack.sql script - it ought to be in the contrib
directory. So something like -
psql -f adminpack.sql postgres
- ought to do it.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie