Re: Server Instrumentation

From: "Brett Maton" <matonb(at)ltresources(dot)co(dot)uk>
To: "'carlosinfl (dot)'" <carlos(dot)mennens(at)gmail(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Server Instrumentation
Date: 2013-06-18 16:30:16
Message-ID: 002501ce6c41$1ea7f1c0$5bf7d540$@ltresources.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Have look see what postgres packages are available....

$ yum list | grep postgres

My only other suggestion would be to install the postgresql yum repo
package....

Brett

-----Original Message-----
From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of carlosinfl .
Sent: 18 June 2013 16:15
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] 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

--
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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message bhanu udaya 2013-06-18 17:31:31 Postgres DB crashing
Previous Message carlosinfl . 2013-06-18 15:14:50 Re: Server Instrumentation