Re: Server Instrumentation

On Tue, Jun 18, 2013 at 1:13 AM, Brett Maton <matonb@ltresources.co.uk> wrote:
> Hi Carlos,
>
>   I'm guessing you want the "adminpack" for use with pgadmin.
>   It's usually bundled in the postgresql92-contrib RPM with EL distros.
>
> As root install the package
> # yum install postgresql92-contrib

I am using Amazon EC2 AMI image in the EC2 cloud which I assume is
some version of RHEL with a 3.4 kernel and more bleeding edge packages
however their repo doesn't appear to have it:

[carlos@db1 ~]$ sudo yum search postgresql92-contrib
[sudo] password for carlos:
Loaded plugins: priorities, security, update-motd, upgrade-helper
amzn-main                                              | 2.1 kB     00:00
amzn-updates                                              | 2.3 kB     00:00
Warning: No matches found for: postgresql92-contrib
No Matches found

>
> As postgres
> $ psql
> postgres=# CREATE EXTENSION adminpack;
> CREATE EXTENSION
>
> You can list installed extensions with \dx
>
> postgres=# \dx
>                         List of installed extensions
>    Name    | Version |   Schema   |               Description
> -----------+---------+------------+-----------------------------------------
>  adminpack | 1.0     | pg_catalog | administrative functions for PostgreSQL
>  plpgsql   | 1.0     | pg_catalog | PL/pgSQL procedural language
>
>
> Regards,
> Brett
> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of carlosinfl .
> Sent: 17 June 2013 22:03
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Server Instrumentation
>
> I have a Amazon EC2 AMI running with PostgreSQL 9.2 installed. It appears to
> be a RHEL based distribution however I need to get server instrumentation
> installed on this virtual server. Does anyone know how I can accomplish
> this? I don't even see a proper download for my version of PostgreSQL 9.2.
>
> Can anyone please help me? I've used Google & FAQ's to no avail.
>
> Please help!
>
> --
> Carlos Mennens
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To
> make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>



--
Carlos Mennens