Re: Enabling Server Instrumentation on 8.4.1 - Mailing list pgsql-general

From Arnold, Sandra
Subject Re: Enabling Server Instrumentation on 8.4.1
Date
Msg-id 54E5385D47A89542BC678F5426799F390448A824A4@OSTIEX01.osti.gov
Whole thread Raw
In response to Re: Enabling Server Instrumentation on 8.4.1  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Aleksey Tsalolikhin
Date:
Subject: Re: Why are there pg_dump errors in my Apache httpd error_log ? (Postgres 8.3.7 on CentOS 5)
Next
From: David Wall
Date:
Subject: pg_dump on Linux with pg_restore on Windows?