Обсуждение: 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
Hi Carlos, I'm guessing you want the "adminpack" for use with pgadmin. It's usually bundled in the postgresql92-contrib RPM with ELdistros. As root install the package # yum install postgresql92-contrib 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 | administrativefunctions for PostgreSQLplpgsql | 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
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
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@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of carlosinfl . Sent: 18 June 2013 16:15 To: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] 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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support