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

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 +0000
From: tim.clarke@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

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

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

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 <pierce@hogranch.com>:

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.

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

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

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

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

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.

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