Thread: installing pgAdmin3 1.6.2 on FC6

Hi,<br /><br />I am a novice FC6 user, and trying to upgrade pgAdmin3 from version 1.4.3 (default) to 1.6.2<br
/>However,it seems yum doesn't find the libs that it depends on (e.g. wxWidgets 2.8, yum output below)<br />Since you
areoffering binaries for FC6 i figure that i should't have to build the deps from source? <br />Am i missing a
repositorywhere these can be found? I've been reading about all kinds of trouble with installing wxWidgets 2.8 on FC6,
butwhy offer ready-built pgAdmin3 1.6.2 if there can be no wxWidgets 2.8??<br /><br />thx,<br /><br />Willy-Bas Loos<br
/><br/>-- yum errors--<br />Error: Missing Dependency: libwx_baseu-2.8.so.0 is needed by package pgadmin3<br />Error:
MissingDependency: libwx_gtk2u_adv-2.8.so.0(WXU_2.8) is needed by package pgadmin3 <br />Error: Missing Dependency:
libwx_gtk2u_xrc-2.8.so.0is needed by package pgadmin3<br />Error: Missing Dependency: libwx_gtk2u_ogl-2.8.so.0 is
neededby package pgadmin3<br />Error: Missing Dependency: libwx_gtk2u_adv-2.8.so.0 is needed by package pgadmin3<br
/>Error:Missing Dependency: libwx_gtk2u_core-2.8.so.0 is needed by package pgadmin3<br />Error: Missing Dependency:
libpq.so.5is needed by package pgadmin3<br />Error: Missing Dependency: libwx_gtk2u_stc- 2.8.so.0(WXU_2.8) is needed by
packagepgadmin3<br />Error: Missing Dependency: libwx_gtk2u_core-2.8.so.0(WXU_2.8) is needed by package pgadmin3<br
/>Error:Missing Dependency: libwx_baseu_net-2.8.so.0(WXU_2.8) is needed by package pgadmin3 <br />Error: Missing
Dependency:libwx_gtk2u_qa-2.8.so.0 is needed by package pgadmin3<br />Error: Missing Dependency:
libwx_baseu_xml-2.8.so.0is needed by package pgadmin3<br />Error: Missing Dependency: libwx_gtk2u_html-2.8.so.0
(WXU_2.8)is needed by package pgadmin3<br />Error: Missing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8) is needed by
packagepgadmin3<br />Error: Missing Dependency: libwx_baseu-2.8.so.0(WXU_2.8) is needed by package pgadmin3 <br
/>Error:Missing Dependency: libwx_gtk2u_html-2.8.so.0 is needed by package pgadmin3<br />Error: Missing Dependency:
libwx_gtk2u_aui-2.8.so.0is needed by package pgadmin3<br />Error: Missing Dependency: libwx_baseu_net-2.8.so.0 is
neededby package pgadmin3<br />Error: Missing Dependency: libwx_gtk2u_xrc-2.8.so.0(WXU_2.8) is needed by package
pgadmin3<br/>Error: Missing Dependency: libwx_gtk2u_ogl-2.8.so.0(WXU_2.8) is needed by package pgadmin3<br /> Error:
MissingDependency: libwx_gtk2u_stc-2.8.so.0 is needed by package pgadmin3<br />-- end of yum eerors --<br /> 

Hi,

On Mon, 2007-01-22 at 13:34 +0100, Willy-Bas Loos wrote:
> Am i missing a repository where these can be found? I

We don't have a yum repo for it; but there is an FTP repo:

http://www.postgresql.org/ftp/pgadmin3/release/v1.6.2/fedora-core-6/

See the wx and rpm directories.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

Ok thanks, guess i missed that one :x
So after i upgraded wxWidgets, it says i need to upgrade to libpq.so.5.
But i can't upgrade, because all kinds of software (i.e. postgresql-contrib) still depends on libpq.so.4 , because i'm running PostgreSQL 8.1.6

It's not necesarry to upgrade the backend for a new pgAdmin, or is it?
I know that on Windows it isnt't, why should it be necessary on Linux?


thx,

Willy-Bas Loos

Willy-Bas Loos wrote:
> Ok thanks, guess i missed that one :x
> So after i upgraded wxWidgets, it says i need to upgrade to libpq.so.5.
> But i can't upgrade, because all kinds of software (i.e. 
> postgresql-contrib) still depends on libpq.so.4 , because i'm running 
> PostgreSQL 8.1.6
>
> It's not necesarry to upgrade the backend for a new pgAdmin, or is it?
> I know that on Windows it isnt't, why should it be necessary on Linux?

On Windows I think it is necessary, as PgAdmin has it's own libpq.dll - 
my version from 1.6.2 on Windows XP is "8.2.0.6338", so is obviously 
from the 8.2.0 series of PostgreSQL, which would equate to libpq.so.5 on 
Linux/Unix.  The server doesn't have to be upgraded, but the client 
library PgAdmin uses evidently does.

I don't know whether the following would work (I've done a similar thing 
in the past), I know it's nasty and crude, but it might work?
Download the source of PostgreSQL 8.2.x, and build it (./configure && 
make), but don't do make install.
Find the libpq.so.5 file from the newly-built source tree and place it 
in /lib, then sym-link /usr/lib/libpq.so.5 and /usr/local/lib/libpq.so.5 
to it.

Andy.

<span class="gmail_quote"></span>>On Windows I think it is necessary, as PgAdmin has it's own libpq.dll -<br
/>>myversion from 1.6.2 on Windows XP is "8.2.0.6338", so is obviously<br />>from the 8.2.0 series of PostgreSQL,
whichwould equate to libpq.so.5 on<br />>Linux/Unix.  The server doesn't have to be upgraded, but the client<br
/>>libraryPgAdmin uses evidently does.<br /><br />You´re right, pgAdmin depends on that dll, but it stores a new one
fora new major version (each of which has a seperate folder in "C:/Program Files/pgAdminIII/"). I have pgAdmin 1.4.3
(libpq.dllversion 8.1.4.6142) and 1.6.1 (libpq.dll version 8.1.5.6286) running on the same machine with no problems.
Theback-end is version 8.1.0.<br />I guess what you are proposing for linux is pretty much the same idea, only not as
pretty.<br />I think i´ll try to extract the libpq.so.5 from the rpm, without compiling postgres, and use that<br /><br
/>I´lllet you know if it worked (or not).<br /><br />Cheers,<br /><br />Willy-Bas<br /><br /><br /><br /> 

It didn´t work.
and all the packages depend on those client libraries (e.g. GRASS GIS), so i can forget about just upgrading.
I like the debian style better. Use pg_createcluster and voila: two back-ends with different versions. (though i haven´t tried installing pgAdmin for a different backend version on a debian machine)
Whatever, i guess i´ll just go w/ the flow and accept that a fedora versions come with package versions.
I guess i should brag about this on fedora forums..

Willy-Bas