Обсуждение: pgadmin3 installation on Oracle Linux 6.6 64-bit ?

Tim Clarke

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

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

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

===============================================================================================================================================================================
Install       5 Package(s)

Total download size: 6.9 M
Installed size: 27 M
Is this ok [y/N]: y
Downloading Packages:
Setting up and reading Presto delta metadata
extras/prestodelta |  605 B     00:00
Processing delta metadata
Package(s) data still to download: 6.9 M
(1/5): SDL-1.2.14-3.el6.x86_64.rpm | 193 kB     00:00
(2/5): libXxf86vm-1.1.3-2.1.el6.x86_64.rpm |  16 kB     00:00
(3/5): pgadmin3_92-1.18.1-2.rhel6.x86_64.rpm | 3.2 MB     00:00
(4/5): wxBase-2.8.12-1.el6.centos.x86_64.rpm | 572 kB     00:00
(5/5): wxGTK-2.8.12-1.el6.centos.x86_64.rpm | 2.9 MB     00:00

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 3.6 MB/s | 6.9 MB     00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
   Installing : wxBase-2.8.12-1.el6.centos.x86_64 1/5
   Installing : libXxf86vm-1.1.3-2.1.el6.x86_64 2/5
   Installing : SDL-1.2.14-3.el6.x86_64 3/5
   Installing : wxGTK-2.8.12-1.el6.centos.x86_64 4/5
   Installing : pgadmin3_92-1.18.1-2.rhel6.x86_64 5/5
   Verifying  : wxGTK-2.8.12-1.el6.centos.x86_64 1/5
   Verifying  : wxBase-2.8.12-1.el6.centos.x86_64 2/5
   Verifying  : pgadmin3_92-1.18.1-2.rhel6.x86_64 3/5
   Verifying  : SDL-1.2.14-3.el6.x86_64 4/5
   Verifying  : libXxf86vm-1.1.3-2.1.el6.x86_64 5/5

Installed:
   pgadmin3_92.x86_64 0:1.18.1-2.rhel6

Dependency Installed:
   SDL.x86_64 0:1.2.14-3.el6           libXxf86vm.x86_64
0:1.1.3-2.1.el6           wxBase.x86_64 0:2.8.12-1.el6.centos
wxGTK.x86_64 0:2.8.12-1.el6.centos

Complete!

--
john, recycling bits in santa cruz

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

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
sameOS. 
>
> I am having problems installing pdadmin3 rpms on Oracle Linux 6.6 64-bit.I selected the RedHat compatible
installationi.e. without the Oracle enterprise kernel.It complains about missing libwx_gtk* packages when I try to do
yuminstall 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*
rpmsare 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
OracleLinux 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
installedusing 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

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.klaver@aklaver.com

On 28 March 2015 at 02:14, Yuri Budilov <yuri.budilov@hotmail.com> wrote:

> 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'm often somewhat surprised that people expect to have GUI tools on
database servers. Why would you really? You can connect from anywhere
using your OS of choice (or rather, the choice of your employer in
most cases) - it's perfectly fine to run pgadmin3 on Windows to
connect to a PostgreSQL database on Oracle Linux.

And why waste potential DB cycles on a graphical environment? You don't need it.
For most things it's plenty (and frequently a lot more powerful and
reliable) to have a textual user interface through a remote terminal
session over SSH or equivalent. Of course, there is a learning curve
to be able to use the UNIX (or Linux) shell and its tools - start with
'man man' if you're new ;)

That said, of course I agree that it should be possible to install
pgadmin3 on Oracle Linux if you'd want to.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.