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!
