Re: [GENERAL] Index corruption

2015-03-29 Thread Bankim Bhavsar
 We'll upgrade to 9.2.10 and attempt to reproduce the issue.

Been running the same test with postgres 9.2.10 for over 48 hrs and we are 
unable to reproduce the index corruption issue observed earlier with 9.2.0.

Thanks for the help everyone!!
-Bankim.


From: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org] 
on behalf of Kevin Grittner [kgri...@ymail.com]
Sent: Tuesday, March 24, 2015 12:47 PM
To: John R Pierce; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Index corruption

John R Pierce pie...@hogranch.com wrote:
 On 3/24/2015 12:05 PM, Bankim Bhavsar wrote:

 If possible, can someone point to corruption related issues fixed
 after 9.2.0?

 in the postgres manual, see the release notes for 9.2.1 through 9.2.10

You can find links to those from here:

http://www.postgresql.org/docs/9.2/static/release.html

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?

2015-03-29 Thread Nicolas Paris
Change OS, or change GUI tool
https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

2015-03-29 9:59 GMT+02:00 John R Pierce pie...@hogranch.com:

 On 3/29/2015 12:48 AM, Yuri Budilov wrote:

 Red Hat/Oracle Linux 6.x


 is that anything like Ford/Chevy ?

 Oracle Linux, while originally forked from Red Hat Enterprise Linux aka
 RHEL, has diverged significantly and is now its own thing. AFAIK, the
 Postgres yum repository has made no effort at maintaining compatibility
 with Oracle.   Oracle Linux exists almost solely to help Oracle keep its
 Oracle Database users captive, and for Oracle to capture support revenue
 that might otherwise go to Red Hat.

 If you want a free alternative to RHEL, may I suggest you install CentOS
 ?   its a package by package replica of RHEL, without divergence, other
 than branding.

 # cat /etc/redhat-release
 CentOS release 6.6 (Final)

 # ls /etc/yum.repos.d/pg*
 /etc/yum.repos.d/pgdg-92-centos.repo

 (this system has postgres 9.2 on it for testing purposes)

 # yum install pgadmin3_92
 Loaded plugins: fastestmirror, presto
 Setting up Install Process
 Loading mirror speeds from cached hostfile
  * base: centos.arvixe.com
  * extras: mirrors.sonic.net
  * updates: mirror.web-ster.com
 Resolving Dependencies
 -- Running transaction check
 --- Package pgadmin3_92.x86_64 0:1.18.1-2.rhel6 will be installed
 -- Processing Dependency: wxGTK for package: pgadmin3_92-1.18.1-2.rhel6.
 x86_64
 -- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0(WXU_2.8)(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_stc-2.8.so.0(WXU_2.8)(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_html-2.8.so.0(WXU_2.8)(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_core-2.8.so.0(WXU_2.8)(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8.5)(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8)(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_adv-2.8.so.0(WXU_2.8)(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu_xml-2.8.so.0(WXU_2.8)(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu_net-2.8.so.0(WXU_2.8)(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8.5)(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8)(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0()(64bit) for package:
 pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_stc-2.8.so.0()(64bit) for package:
 pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_html-2.8.so.0()(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_core-2.8.so.0()(64bit) for
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0()(64bit) for package:
 pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_adv-2.8.so.0()(64bit) for package:
 pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu_xml-2.8.so.0()(64bit) for package:
 pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu_net-2.8.so.0()(64bit) for package:
 pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu-2.8.so.0()(64bit) for package:
 pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Running transaction check
 --- Package wxBase.x86_64 0:2.8.12-1.el6.centos will be installed
 --- Package wxGTK.x86_64 0:2.8.12-1.el6.centos will be installed
 -- Processing Dependency: libXxf86vm.so.1()(64bit) for package:
 wxGTK-2.8.12-1.el6.centos.x86_64
 -- Processing Dependency: libSDL-1.2.so.0()(64bit) for package:
 wxGTK-2.8.12-1.el6.centos.x86_64
 -- Running transaction check
 --- Package SDL.x86_64 0:1.2.14-3.el6 will be installed
 --- Package libXxf86vm.x86_64 0:1.1.3-2.1.el6 will be installed
 -- Finished Dependency Resolution

 Dependencies Resolved

 
 
 ===
  Package Arch Version RepositorySize
 
 
 ===
 Installing:
  pgadmin3_92 x86_64 1.18.1-2.rhel6 pgdg92
  3.2 M
 Installing for dependencies:
  SDL x86_64 1.2.14-3.el6 base 193 k
  libXxf86vm x86_64 1.1.3-2.1.el6 base  16 k
  wxBase x86_64 

Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?

2015-03-29 Thread Adrian Klaver

On 03/29/2015 12:48 AM, Yuri Budilov wrote:

thanks Tim,

I ran yum whatprovides and received no matches found.


What repos are you using?

See Devims answer for the Postgres community repo.



I believe that pgadmin3 uses wxWidgets (according to the web site) but I
can not find them in installable rpm format for Red Hat/Oracle Linux 6.x
on their web site.


The expectation is that would be handled by the packaging system for the 
distribution. In the event that is not the case, the download site at 
pgAdmin (http://www.pgadmin.org/download/) gives you links to other 
options, including the link Devim mentioned.






the gtk libraries are already installed on my Linux, as is postgres 9.4.
The errors from pgadmin3 installation appear to be specific to
libwx_gtk* libraries, which are probably part of wxWidgets.org.

I find this hard to believe that to just install and use pgadmin3 (as a
DBA, not as a C++ programmer!) on Red Hat/Oracle Linux I must be
building complete C++ application from sources using all sorts of
disparate libraries.
wxWidgets, I am sure, will have a bunch of other prerequisites, its like
a dog chasing its tail.
I just want to install and use pgadmin3 on one of the most common Linux
platforms, RHEL.


No you want to use it on Oracle Linux which is a derived distro, created 
by a company who sees Postgres as a competitor. Not sure they are all 
that interested in making Postgres easy to use.



I expected smooth sailing, the PostgreSQL 9.4 was certainly easy to
install and get going on RHEL/OL.
Alas, not pgadmin4.

What have I missed? Is there a step by step document describing how to
do this (i failed to find it)?
Is the prerequisite for pdagmin3 *installation* requires mastery of all
of: Linux, C++ and wsWidgets?

Is pgadmin3 not a widely used tool by PostgeSQL DBA community which is
why there is such lack of good documentation on how to install it?


I would say psql is probably a more widely used tool. The only time I 
use pgAdmin is when I am trying to solve other peoples problems with it. 
From what I have seen it is a good tool, it just does not fit my way of 
working.





Thank you for reading thus far.
Yuri Budilov






--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?

2015-03-29 Thread John R Pierce

On 3/29/2015 12:48 AM, Yuri Budilov wrote:

Red Hat/Oracle Linux 6.x


is that anything like Ford/Chevy ?

Oracle Linux, while originally forked from Red Hat Enterprise Linux aka 
RHEL, has diverged significantly and is now its own thing. AFAIK, the 
Postgres yum repository has made no effort at maintaining compatibility 
with Oracle.   Oracle Linux exists almost solely to help Oracle keep its 
Oracle Database users captive, and for Oracle to capture support revenue 
that might otherwise go to Red Hat.


If you want a free alternative to RHEL, may I suggest you install CentOS 
?   its a package by package replica of RHEL, without divergence, other 
than branding.


# cat /etc/redhat-release
CentOS release 6.6 (Final)

# ls /etc/yum.repos.d/pg*
/etc/yum.repos.d/pgdg-92-centos.repo

(this system has postgres 9.2 on it for testing purposes)

# yum install pgadmin3_92
Loaded plugins: fastestmirror, presto
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: centos.arvixe.com
 * extras: mirrors.sonic.net
 * updates: mirror.web-ster.com
Resolving Dependencies
-- Running transaction check
--- Package pgadmin3_92.x86_64 0:1.18.1-2.rhel6 will be installed
-- Processing Dependency: wxGTK for package: 
pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0(WXU_2.8)(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_stc-2.8.so.0(WXU_2.8)(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_html-2.8.so.0(WXU_2.8)(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_core-2.8.so.0(WXU_2.8)(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8.5)(64bit) 
for package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8)(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_adv-2.8.so.0(WXU_2.8)(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_baseu_xml-2.8.so.0(WXU_2.8)(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_baseu_net-2.8.so.0(WXU_2.8)(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8.5)(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8)(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0()(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_stc-2.8.so.0()(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_html-2.8.so.0()(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_core-2.8.so.0()(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_aui-2.8.so.0()(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_gtk2u_adv-2.8.so.0()(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_baseu_xml-2.8.so.0()(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_baseu_net-2.8.so.0()(64bit) for 
package: pgadmin3_92-1.18.1-2.rhel6.x86_64
-- Processing Dependency: libwx_baseu-2.8.so.0()(64bit) for package: 
pgadmin3_92-1.18.1-2.rhel6.x86_64

-- Running transaction check
--- Package wxBase.x86_64 0:2.8.12-1.el6.centos will be installed
--- Package wxGTK.x86_64 0:2.8.12-1.el6.centos will be installed
-- Processing Dependency: libXxf86vm.so.1()(64bit) for package: 
wxGTK-2.8.12-1.el6.centos.x86_64
-- Processing Dependency: libSDL-1.2.so.0()(64bit) for package: 
wxGTK-2.8.12-1.el6.centos.x86_64

-- Running transaction check
--- Package SDL.x86_64 0:1.2.14-3.el6 will be installed
--- Package libXxf86vm.x86_64 0:1.1.3-2.1.el6 will be installed
-- Finished Dependency Resolution

Dependencies Resolved

===
 Package Arch Version RepositorySize
===
Installing:
 pgadmin3_92 x86_64 1.18.1-2.rhel6 pgdg92   
3.2 M

Installing for dependencies:
 SDL x86_64 1.2.14-3.el6 base 193 k
 libXxf86vm x86_64 1.1.3-2.1.el6 base  16 k
 wxBase x86_64 2.8.12-1.el6.centos extras   
572 k
 wxGTK x86_64 2.8.12-1.el6.centos extras   
2.9 M


Transaction Summary

Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?

2015-03-29 Thread John R Pierce

On 3/29/2015 1:39 AM, Yuri Budilov wrote:
my employer runs Oracle Linux 6.x and also Red Hat 6.x, so if we were 
to drop Oracle database and take PostgreSQL instead, I am afraid, 
everything must work on those two Linux platforms.

We pay for support from Oracle and Red Hat for Linux OS.


its installing on redhat isn't it ?  might be worth opening a ticket 
with Oracle to find out why its not working on their system, then.


On the client OS we use Windows 7 64-bit so the PostgreSQL tools and 
all drivers (JDBC, .NET, etc) need to also work on Windows as well as 
on Linux.


If this is not available and we need to switch to Centos or another 
flavour of Linux, I am afraid, PostgreSQL is dead in the water, it 
wont even get a look in.


well, these were the only RPMs' it took to install pgadmin3 for postgres 
9.2 on my EL 6.6 system... so I dunno why Oracle Linux is not working.


SDL-1.2.14-3.el6.x86_64.rpm
libXxf86vm-1.1.3-2.1.el6.x86_64.rpm
pgadmin3_92-1.18.1-2.rhel6.x86_64.rpm
wxBase-2.8.12-1.el6.centos.x86_64.rpm
wxGTK-2.8.12-1.el6.centos.x86_64.rpm

I just ran the install for 9.4 and other than the actual pgadmin3 rpm, 
the rest of the dependencies are the same.




--
john, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?

2015-03-29 Thread Devrim Gündüz

Hi,

http://yum.postgresql.org/

has all the packages for pgadmin3 and its dependencies for Oracle Linux
6.X.

Regards, Devrim

On Sat, 2015-03-28 at 12:14 +1100, Yuri Budilov wrote:
 Hello everyone.
 I am new to PostgreSQL and Linux (coming across from Microsoft SQL Server).
 I installed PostgreSQL 9.4 on Oracle Linux 6.6 and its working ok (psql, 
 etc). Now I try to install pgadmin3 on the same OS.
 
 I am having problems installing pdadmin3 rpms on Oracle Linux 6.6 64-bit.I 
 selected the RedHat compatible installation i.e. without the Oracle 
 enterprise kernel.It complains about missing libwx_gtk* packages when I try 
 to do yum install pgadmin3*.86_64.rpm.
 The ISO file for Oracle Linux 6.6 (Packages directory of the distribution) 
 does not have libwx* rpms and the gtk* rpms are already installed on my 
 Oracle Linux 6.6 if I try to install them again. Perhaps I am looking in the 
 wrong place??
 Is there any document or web site which clearly tells me what i need to 
 pre-install so that I can install pgadmin3 on Oracle Linux 6.x 64-bit ?
 I prefer not downloading the source code and trying to build it all in-place, 
 so looking for binaries ready to be installed using rpm or yum. I dont have 
 Red Hat support contract, hoping to make it work on Oracle Linux 6.6 with 
 RHEL kernel.
 If this is the wrong forum for this question - please tell me where to ask 
 this question.
 many thanks in advanceYuri BudilovAUstralia   
   


-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR



signature.asc
Description: This is a digitally signed message part


Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?

2015-03-29 Thread Yuri Budilov
thanks Tim,
I ran yum whatprovides and received no matches found.
I believe that pgadmin3 uses wxWidgets (according to the web site) but I can 
not find them in installable rpm format for Red Hat/Oracle Linux 6.x on their 
web site.
the gtk libraries are already installed on my Linux, as is postgres 9.4. The 
errors from pgadmin3 installation appear to be specific to libwx_gtk* 
libraries, which are probably part of wxWidgets.org.
I find this hard to believe that to just install and use pgadmin3 (as a DBA, 
not as a C++ programmer!) on Red Hat/Oracle Linux I must be building complete 
C++ application from sources using all sorts of disparate libraries. wxWidgets, 
I am sure, will have a bunch of other prerequisites, its like a dog chasing its 
tail. I just want to install and use pgadmin3 on one of the most common Linux 
platforms, RHEL.I expected smooth sailing, the PostgreSQL 9.4 was certainly 
easy to install and get going on RHEL/OL. Alas, not pgadmin4.
What have I missed? Is there a step by step document describing how to do this 
(i failed to find it)?Is the prerequisite for pdagmin3 *installation* requires 
mastery of all of: Linux, C++ and wsWidgets? 
Is pgadmin3 not a widely used tool by PostgeSQL DBA community which is why 
there is such lack of good documentation on how to install it?

Thank you for reading thus far.Yuri Budilov

Date: Sat, 28 Mar 2015 10:56:34 +
From: tim.cla...@manifest.co.uk
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?


  

  
  
Yuri the 'gtk' part suggests graphics libraries to me. Since Oracle
linux is built on RedHat you can usefully use 'yum' package manager
to search that distribution's installed repositories for your file
with: 



sudo yum whatprovides \*libwx\*



You may want to pipe that to less since it may give a long answer.
Scan down for packages that will provide your libwx* file(s) and
then install with 'yum install (package)'.



Good luck!

Tim Clarke
On 28/03/15 01:14, Yuri Budilov wrote:



  
  Hello everyone.



I am new to PostgreSQL and Linux (coming across from
  Microsoft SQL Server).



I installed PostgreSQL 9.4 on Oracle Linux 6.6 and its
  working ok (psql, etc). 
Now I try to install pgadmin3 on the same OS.

  

  
  I am having problems installing pdadmin3 rpms on Oracle
Linux 6.6 64-bit.
  I selected the RedHat compatible installation i.e.
without the Oracle enterprise kernel.
  It complains about missing libwx_gtk* packages when I try
to do yum install pgadmin3*.86_64.rpm.
  

  
  The ISO file for Oracle Linux 6.6 (Packages directory of
the distribution) does not have libwx* rpms and the gtk*
rpms are already installed on my Oracle Linux 6.6 if I try
to install them again. Perhaps I am looking in the wrong
place??
  

  
  Is there any document or web site which clearly tells me
what i need to pre-install so that I can install pgadmin3 on
Oracle Linux 6.x 64-bit ?
  

  
  I prefer not downloading the source code and trying to
build it all in-place, so looking for binaries ready to be
installed using rpm or yum. I dont have Red Hat support
contract, hoping to make it work on Oracle Linux 6.6 with
RHEL kernel.
  

  
  If this is the wrong forum for this question - please
tell me where to ask this question.
  

  
  many thanks in advance
  Yuri Budilov
  AUstralia

  


  

Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?

2015-03-29 Thread Yuri Budilov
thanks,
my employer runs Oracle Linux 6.x and also Red Hat 6.x, so if we were to drop 
Oracle database and take PostgreSQL instead, I am afraid, everything must work 
on those two Linux platforms.We pay for support from Oracle and Red Hat for 
Linux OS.
On the client OS we use Windows 7 64-bit so the PostgreSQL tools and all 
drivers (JDBC, .NET, etc) need to also work on Windows as well as on Linux.
If this is not available and we need to switch to Centos or another flavour of 
Linux, I am afraid, PostgreSQL is dead in the water, it wont even get a look in.
 Date: Sun, 29 Mar 2015 00:59:36 -0700
 From: pie...@hogranch.com
 To: pgsql-general@postgresql.org
 Subject: Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?
 
 On 3/29/2015 12:48 AM, Yuri Budilov wrote:
  Red Hat/Oracle Linux 6.x
 
 is that anything like Ford/Chevy ?
 
 Oracle Linux, while originally forked from Red Hat Enterprise Linux aka 
 RHEL, has diverged significantly and is now its own thing. AFAIK, the 
 Postgres yum repository has made no effort at maintaining compatibility 
 with Oracle.   Oracle Linux exists almost solely to help Oracle keep its 
 Oracle Database users captive, and for Oracle to capture support revenue 
 that might otherwise go to Red Hat.
 
 If you want a free alternative to RHEL, may I suggest you install CentOS 
 ?   its a package by package replica of RHEL, without divergence, other 
 than branding.
 
 # cat /etc/redhat-release
 CentOS release 6.6 (Final)
 
 # ls /etc/yum.repos.d/pg*
 /etc/yum.repos.d/pgdg-92-centos.repo
 
  (this system has postgres 9.2 on it for testing purposes)
 
 # yum install pgadmin3_92
 Loaded plugins: fastestmirror, presto
 Setting up Install Process
 Loading mirror speeds from cached hostfile
   * base: centos.arvixe.com
   * extras: mirrors.sonic.net
   * updates: mirror.web-ster.com
 Resolving Dependencies
 -- Running transaction check
 --- Package pgadmin3_92.x86_64 0:1.18.1-2.rhel6 will be installed
 -- Processing Dependency: wxGTK for package: 
 pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0(WXU_2.8)(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_stc-2.8.so.0(WXU_2.8)(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_html-2.8.so.0(WXU_2.8)(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_core-2.8.so.0(WXU_2.8)(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8.5)(64bit) 
 for package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8)(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_adv-2.8.so.0(WXU_2.8)(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu_xml-2.8.so.0(WXU_2.8)(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu_net-2.8.so.0(WXU_2.8)(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8.5)(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu-2.8.so.0(WXU_2.8)(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_xrc-2.8.so.0()(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_stc-2.8.so.0()(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_html-2.8.so.0()(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_core-2.8.so.0()(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_aui-2.8.so.0()(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_gtk2u_adv-2.8.so.0()(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu_xml-2.8.so.0()(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu_net-2.8.so.0()(64bit) for 
 package: pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Processing Dependency: libwx_baseu-2.8.so.0()(64bit) for package: 
 pgadmin3_92-1.18.1-2.rhel6.x86_64
 -- Running transaction check
 --- Package wxBase.x86_64 0:2.8.12-1.el6.centos will be installed
 --- Package wxGTK.x86_64 0:2.8.12-1.el6.centos will be installed
 -- Processing Dependency: libXxf86vm.so.1()(64bit) for package: 
 wxGTK-2.8.12-1.el6.centos.x86_64
 -- Processing Dependency: libSDL-1.2.so.0()(64bit) for package: 
 wxGTK-2.8.12-1.el6.centos.x86_64
 -- Running transaction check
 --- Package SDL.x86_64 0:1.2.14-3.el6 will be installed
 --- Package libXxf86vm.x86_64 0:1.1.3-2.1.el6 will be installed
 -- Finished Dependency Resolution
 
 Dependencies Resolved