Re: Enabling Server Instrumentation on 8.4.1

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