phpPgAdmin is a web application, written in PHP and web-based administration utility for managing PostgreSQL databases. It handles all the basic functionality as well as some advanced features such as triggers, views and functions. It can create databases, create tables, alter tables and query the data. In this post, i will show how to install phpPgAdmin for PostgreSQL Databases on linux CentOS 6.2 server. Assumed that you have already configured EPEL repository.
[root@centos62 ~]# yum install phpPgAdmin -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.averse.net
* epel: ftp.riken.jp
* extras: mirror.averse.net
* updates: mirror.issp.co.th
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package phpPgAdmin.noarch 0:5.0.3-1.el6 will be installed
--> Processing Dependency: php-pgsql >= 4.2 for package: phpPgAdmin-5.0.3-1.el6.noarch
--> Running transaction check
---> Package php-pgsql.i686 0:5.3.3-3.el6_2.6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================
Package Arch Version Repository Size
====================================================================================================
Installing:
phpPgAdmin noarch 5.0.3-1.el6 epel 909 k
Installing for dependencies:
php-pgsql i686 5.3.3-3.el6_2.6 updates 67 k
Transaction Summary
====================================================================================================
Install 2 Package(s)
Total download size: 976 k
Installed size: 4.9 M
Downloading Packages:
(1/2): php-pgsql-5.3.3-3.el6_2.6.i686.rpm | 67 kB 00:00
(2/2): phpPgAdmin-5.0.3-1.el6.noarch.rpm | 909 kB 00:10
----------------------------------------------------------------------------------------------------
Total 83 kB/s | 976 kB 00:11
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : php-pgsql-5.3.3-3.el6_2.6.i686 1/2
Installing : phpPgAdmin-5.0.3-1.el6.noarch 2/2
Non-fatal POSTIN scriptlet failure in rpm package phpPgAdmin-5.0.3-1.el6.noarch
warning: %post(phpPgAdmin-5.0.3-1.el6.noarch) scriptlet failed, exit status 7
Installed:
phpPgAdmin.noarch 0:5.0.3-1.el6
Dependency Installed:
php-pgsql.i686 0:5.3.3-3.el6_2.6
Complete!