Re: Server Instrumentation

On Tue, Jun 18, 2013 at 1:13 AM, Brett Maton <matonb(at)ltresources(dot)co(dot)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(at)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(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of carlosinfl .
> Sent: 17 June 2013 22:03
> To: pgadmin-support(at)postgresql(dot)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(at)postgresql(dot)org) To
> make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>

--
Carlos Mennens