Tech

pgadmin3 in centos5.5 x64

by Phyllis · April 29, 2011

1. Get pgadmin3-1.8.4-1.el5.x86_64.rpm from CentOS 5 (RHEL 5) – EPEL x86_64 in pkgs.org

2. Install it through “rpm -ivh pgadmin3-1.8.4-1.el5.x86_64.rpm” , but that will result in some dependencies problem :

# rpm -ivh pgadmin3-1.8.4-1.el5.x86_64.rpm
error: Failed dependencies:
libwx_baseu-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_baseu-2.8.so.0(WXU_2.8)(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_baseu_net-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_baseu_net-2.8.so.0(WXU_2.8)(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_baseu_xml-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_adv-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_adv-2.8.so.0(WXU_2.8)(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_aui-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_aui-2.8.so.0(WXU_2.8)(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_core-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_core-2.8.so.0(WXU_2.8)(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_html-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_html-2.8.so.0(WXU_2.8)(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_ogl-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_ogl-2.8.so.0(WXU_2.8)(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_qa-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_richtext-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_stc-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_stc-2.8.so.0(WXU_2.8)(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_xrc-2.8.so.0()(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
libwx_gtk2u_xrc-2.8.so.0(WXU_2.8)(64bit) is needed by pgadmin3-1.8.4-1.el5.x86_64
wxGTK is needed by pgadmin3-1.8.4-1.el5.x86_64

3. Go to the Same site in #1 , and get all those missing packages there ,and install with below order :

% rpm -ivh wxBase-2.8.12-1.el5.x86_64.rpm
% rpm -ivh wxGTK-2.8.12-1.el5.x86_64.rpm
% rpm -ivh pgadmin3-1.8.4-1.el5.x86_64.rpm

Special Note :
1. The above pgadmin3 is of version 3.1.8.4 , which cannot connect to PostgreSQL ver 9.0 or above . You will need to install pgadmin 3.1.12 release to work with with PostgreSQL 9.0. You can install pgadmin 3.1.12 by building from source , but you also need to upgrade the existing PostgreSQL to ver9.0 in order to make a successful build.
2. We should be recommended to use only CentOS 5.5 OS certified packages , installation through “yum install” with default repositories is the way for best stability . Manual installation of RPM (like above) will be the last resort .