how to install pgadmin3 on centos 6.2

Summary: In this post i am trying to explain how to install pgadmin3 on centos server. I have install pgadminIII on cenots 6.2 successfully. I faced a dependency issue during installation and resolve it. procedure are listed below.

Step-1:  I have install postgresql on centos 6.2 server. Setting all the default configuration like listen to address and pg_hba.conf trust to all the address which need to be modified.

Step-2: Install the dbinit for pgsql to start postgresql through init script.

Step-3: Chkconfig postgresql on

Step-4: start postgresql

Step-5: Install pgadminIII

# yum install pgadmin3

Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: mirror-cybernet.lums.edu.pk
* extras: mirror-cybernet.lums.edu.pk
* rpmforge: mir01.syntis.net
* updates: mirror-cybernet.lums.edu.pk
Setting up Install Process
Resolving Dependencies
–> Running transaction check
—> Package pgadmin3.i386 0:1.8.4-1.el5.rf will be installed
–> Processing Dependency: libpq.so.4 for package: pgadmin3-1.8.4-1.el5.rf.i386
–> Finished Dependency Resolution
Error: Package: pgadmin3-1.8.4-1.el5.rf.i386 (rpmforge)
Requires: libpq.so.4
You could try using –skip-broken to work around the problem
You could try running: rpm -Va –nofiles –nodigest

oooppppppppppppppppsssssssssssssssssssssssssssssssss

now what to do ūüėČ

let try goggling .

ohhh trying different methods to resolve but not successful. Downloading rpm finding lib repository bla bla bla.

ūüôā

I find the solution.

I have download one of the rpm from web and install that on my server, that’s work for me. just look it below.

wget http://yum.pgrpms.org/9.0/redhat/rhel-5-i386/compat-postgresql-libs-4-1PGDG.rhel5.i686.rpm

yum install compat-postgresql-libs-4-1PGDG.rhel5.i686.rpm

Then run the command for pgadmin3

yum install pgadmin3

Loaded plugins: fastestmirror, refresh-packagekit, security
Existing lock /var/run/yum.pid: another copy is running as pid 10488.
Another app is currently holding the yum lock; waiting for it to exit…
The other application is: PackageKit
Memory :  32 M RSS ( 80 MB VSZ)
Started: Fri Sep  7 12:29:28 2012 Р00:02 ago
State  : Running, pid: 10488
Another app is currently holding the yum lock; waiting for it to exit…
The other application is: PackageKit
Memory :  33 M RSS ( 81 MB VSZ)
Started: Fri Sep  7 12:29:28 2012 Р00:04 ago
State  : Sleeping, pid: 10488
Another app is currently holding the yum lock; waiting for it to exit…
The other application is: PackageKit
Memory :  33 M RSS ( 81 MB VSZ)
Started: Fri Sep  7 12:29:28 2012 Р00:06 ago
State  : Sleeping, pid: 10488
Loading mirror speeds from cached hostfile
* base: mirror-cybernet.lums.edu.pk
* extras: mirror-cybernet.lums.edu.pk
* rpmforge: mir01.syntis.net
* updates: mirror-cybernet.lums.edu.pk
Setting up Install Process
Resolving Dependencies
–> Running transaction check
—> Package pgadmin3.i386 0:1.8.4-1.el5.rf will be installed
–> Finished Dependency Resolution

Dependencies Resolved

================================================
Package          Arch         Version           Repository        Size
================================================
Installing:
pgadmin3      i386     1.8.4-1.el5.rf      rpmforge         4.2 M

Transaction Summary
=================================================
Install       1 Package(s)

Total download size: 4.2 M
Installed size: 11 M
Is this ok [y/N]: y
Downloading Packages:
pgadmin3-1.8.4-1.el5.rf.i386.rpm                   | 4.2 MB     00:09
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : pgadmin3-1.8.4-1.el5.rf.i386                         1/1
Verifying  : pgadmin3-1.8.4-1.el5.rf.i386                         1/1

Installed:
pgadmin3.i386 0:1.8.4-1.el5.rf

Complete!
…………………………………………………………

pgadmin3

and get it done.

Hope this will help some one and saved time.

Comments
  1. 3 years ago

Leave a Reply

Your email address will not be published. Required fields are marked *