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(at)iol(dot)ie]
Sent: Tuesday, November 03, 2009 10:51 AM
To: Arnold, Sandra
Cc: pgsql-general(at)postgresql(dot)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(at)iol(dot)ie